Forum Discussion
Solved
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...
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.
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.