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 | Orders Created |
| Name1 | 01/10/20 | 33 |
| Name2 | 01/10/20 | 3 |
| Name3 | 01/10/20 | 37 |
| Name1 | 02/10/20 | 44 |
| Name2 | 02/10/20 | 0 |
How would I go about this?
Thanks,
Morgan
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.
3 Replies
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.
