Oct 13 2020 07:19 AM - edited Oct 21 2020 07:13 AM
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
Oct 13 2020 07:44 AM
Is the number of filled-in date columns fixed? Or does it vary by name?
Oct 13 2020 07:48 AM
The number of columns are fixed for all names, regardless of data, so some of the cells are 0.
Oct 13 2020 07:52 AM
SolutionThat'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.
Oct 13 2020 07:52 AM
SolutionThat'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.