August 31, 2021
I need to generate a pivot table to show on which date which person is occupied and tasked on what task. The problem is I am not able to put both dates and names of individuals into columns for ease of extraction during pivot table generation as there could be multiple people occupied on the same day doing various task. Is there any way to generate the data based on what i wanted? For example, for individual A - 02 Aug, 03 Aug, 04 Aug. I have included some of the possible results to be shown in the pivot table on the results sheet and i have some sample data ready as well. It is ok if the type of task they are assigned to is not shown in the results, but i needed the date and name of the individual to be shown in the pivot table based on the date range filtered. Otherwise, can anyone suggest how i can better arrange my data so that i am able to get similar results? thank you very much.
attaching my sample data link below:
July 16, 2010
Welcome to our forum. The problem is caused by your data being in the wrong layout for a PivotTable. You need to unpivot the name columns so you have one column with the names and another with the letter. You can use Power Query to unpivot the data.
This PivotTable tutorial also explains why data in this layout causes the problem.
I hope that points you in the right direction.