I believe that I may be stretching the capabilities of Excel Pivot Tables here but thought I would pose the challenge to see if anyone can help me out...
I'm trying to build a pivot table that has sequential dates as the columns, names of people as rows, and 1's or 0's in the value fields. 1's represent that the person was on location at that date and 0's represent that the person was off location.
The problem that I have is that the source data contains one column with peoples names, another with "Arrival Date", and another with "Departure Date". People's names can be repeated multiple times.
The attached spreadsheet contains a tab called "Desired Pivot Table". It is a table built with formulas that shows what I would like the pivot table to show.
I am OK with the solution utilizing power query if necessary but would like to avoid formulas.
Thanks for the help!
Bookmarks