Forum Discussion
Solved
How to transpose table?
My data is as below 01/10/20 02/10/20 03/10/20 Name1 33 44 34 Name2 3 0 12 Name3 37 28 24 And I want to convert it to the following layout: Name Date Ord...
That's easier with Power Query - query table with data or named range; select column with names; unpivot other columns and do some cosmetic as data types and renaming of columns; land result back.
Is the number of filled-in date columns fixed? Or does it vary by name?
The number of columns are fixed for all names, regardless of data, so some of the cells are 0.