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.
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.