I have a data dump I would like to put into a pivot table to know the number of days someone worked in a week. However due to the data dump when i put this into the pivot table the numbers are misleading when somone has worked on multiple activities on the same day. This counts as three or two days when really it was only one day. Is there any way to easily clean the data or fix this problem.
I have copied a sample of the data and pivot table. The real data is extremely long thus I can't clean this manually.
Thanks in advance.