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 |
to the following format
| Project Number | Qtr | Amount |
| 11516 | Qtr1 | 25000 |
| 11516 | Qtr2 | 32000 |
| 11516 | Qtr3 | 12000 |
| 11517 | Qtr1 | 16000 |
| 11517 | Qtr2 | 14000 |
| 11517 | Qtr3 | 2000 |
| 11435 | Qtr1 | 89000 |
| 11517 | Qtr2 | 42000 |
| 11517 | Qtr3 | 34000 |
The easiest is with Power Query
- query the table, select Project Number column, Unpivot other columns, Rename headers, load back to sheet.
3 Replies
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
