Forum Discussion
Solved
How to transform two way table in excel into simple long table
Hello all , Please help me how to transform the following table Project Number Qtr1 Qtr2 Qtr3 11516 25000 32000 12000 11517 16000 14000 2000 11435 89000 42000 34000 ...
The easiest is with Power Query
- query the table, select Project Number column, Unpivot other columns, Rename headers, load back to sheet.
The easiest is with Power Query
- query the table, select Project Number column, Unpivot other columns, Rename headers, load back to sheet.
- Sergei, Many thanks, this solution worked perfectly fine.
Das_Chenji , you are welcome
