Forum Discussion
Solved
How to convert cross table
Please advise how to convert below in PowerBI desktop
| Date | A | B | C |
| 4/1/2020 | 230 | 392 | 392 |
| 4/2/2020 | 390 | 44 | 454 |
| 4/3/2020 | 550 | 392 | 454 |
| 4/4/2020 | 710 | 546 | 5645 |
| 4/5/2020 | 870 | 392 | 454 |
| 4/6/2020 | 1030 | 574 | 448 |
| 4/7/2020 | 1190 | 392 | 454 |
| 4/8/2020 | 1350 | 474 | 454 |
into something like below
| Header | Header | Values |
| 4/1/2020 | A | 230 |
| 4/2/2020 | A | 390 |
| 4/3/2020 | A | 550 |
| 4/4/2020 | A | 710 |
| 4/5/2020 | A | 870 |
| 4/6/2020 | A | 1030 |
| 4/7/2020 | A | 1190 |
| 4/8/2020 | A | 1350 |
| 4/1/2020 | B | 392 |
| 4/2/2020 | B | 44 |
| 4/3/2020 | B | 392 |
| 4/4/2020 | B | 546 |
| 4/5/2020 | B | 392 |
| 4/6/2020 | B | 574 |
| 4/7/2020 | B | 392 |
| 4/8/2020 | B | 474 |
| 4/1/2020 | C | 392 |
| 4/2/2020 | C | 454 |
| 4/3/2020 | C | 454 |
| 4/4/2020 | C | 5645 |
| 4/5/2020 | C | 454 |
| 4/6/2020 | C | 448 |
| 4/7/2020 | C | 454 |
| 4/8/2020 | C | 454 |
In Power Query, select the date column, then on the Transformation ribbon, select "Unpivot Other Columns."
3 Replies
In Power Query, select the date column, then on the Transformation ribbon, select "Unpivot Other Columns."
Thank you for quick reply
Glad to help dhirendra59
Mark it as a solution if it has answered the question so others know this is the solution if they are looking later.
