Forum Discussion
Pivot tables, more than one person/unit assigned to a task.
Hi, I have the example table below. How do I create a pivot table that lists the "Tasks" each Unit is responsible for? The "Unit" could be in the column "Unit" or "Unit 2" as more than one unit may...
SueWhitt You would have to restructure the data so that you have only one column for the Unit, thus creating multiple rows for tasks that belong to multiple units. In the attached example I did it manually, but in real life you could do it with Power Query (unpivot) for example.
