Microsoft Excel
Excel FILTER with UNIQUE and TRANSPOSE: Build Dynamic Lists
Turn a flat list of names and departments into a column per department that updates on its own. UNIQUE pulls the distinct departments, TRANSPOSE turns them into headers, and FILTER drops the right names underneath each one.