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.
Many roads lead to Rome.
This is also the case with Excel, there are many ways to find a solution ... even tailor made.
In the inserted file you can see it with a very simple pivot as an example.
I also wish you a lot of fun with Excel.
Nikolino
I know that I don't know (Socrates)