I'm using a excel spreadsheet at my reception desk to log in visitors in the following fashion:
[NAME] [HOUR] JOHN 09:00 MARC 09:00 DAVID 10:00 JOHN 11:00 MARC 12:00 DAVID 13:00
Obviously there are better tools for the job but no choice here. I'm asked to make a pivot table from this data which should then look like this:
[JOHN] [MARC] [DAVID] 09:00 09:00 10:00 11:00 12:00 13:00
But I can only get the pivot table to make operaitons out of the values (for example sum of 09:00 + 10:00 etc) whereas I'm trying to simply enumerate them. Maybe using a pivot table isn't the right solution here?
Thanks for reading