Forum Discussion
JCornelison
Mar 14, 2021Copper Contributor
Is this possible with Pivot Tables, or...
I’ve a time sheet of hours worked by volunteers that I’d like to analyze. Current: Name 3/1/21 3/2/21 Bob 3 2.5 Sally 1 5 Desired: Name Date Ho...
- Mar 14, 2021
JCornelison Easiest done with Power Query (Windows only!)
Query the table (as in Current:)
Select the Name column
Right-click and select "Unpivot other columns"
Close and load back to Excel.
More details in the attached link.
Riny_van_Eekelen
Mar 14, 2021Platinum Contributor
JCornelison Easiest done with Power Query (Windows only!)
Query the table (as in Current:)
Select the Name column
Right-click and select "Unpivot other columns"
Close and load back to Excel.
More details in the attached link.