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:

https://docs.google.com/spreadsheets/d/1h82rpek6z50kvWgwjqFbohWg7lt67gWay_ykjuqIoVc/edit?usp=sharing