Hi Everyone, I'm trying to create a Pivot Table with employee data that also has time values in it. But i can't figure out how to get the time to show the result in the raw data. I guess the best was to describe it is similar to using an Index formula and returning the answer. Is there a way to do that with a pivot table?
Here's an example of the raw data and the desired outcome attached.
Thanks in advance for your help.
LouisT
Here's an example of the raw data and the desired outcome attached.
Thanks in advance for your help.
LouisT