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.
As variant
with
=LET(dates, $C$2:$E$2, names, $B$3:$B$4, data, $C$3:$E$4,
nDates, COLUMNS(dates),
nNames, ROWS(names),
k, SEQUENCE(nDates*nNames),
CHOOSE({1,2,3},
INDEX(names,INT((k-1)/nDates)+1),
INDEX(dates,,MOD(k-1,nDates)+1),
INDEX(data,INT((k-1)/nDates)+1,MOD(k-1,nDates)+1))
)
nice one