Forum Discussion
Solved
How to transpose and shape a table
Hi all, I have a table like this:
| COD | A_VAR | B_VAR | C_VAR |
| 1 | 70,00% | 30,00% | |
| 2 | 25,00% | 25,00% | 50,00% |
| 3 | 10,00% | 70,00% | 20,00% |
And I want to create a new table based on previous like this:
| COD | VAR | VALUE |
| 1 | A | 70,00% |
| 1 | B | 30,00% |
| 2 | A | 25,00% |
| 2 | B | 25,00% |
| 2 | C | 50,00% |
| 3 | A | 10,00% |
| 3 | B | 70,00% |
| 3 | C | 20,00% |
Is it possible?
Hi caseski , in Power Query, select COD column, and select Unpivot others columns, like the image:
The result:
Best regards
1 Reply
Hi caseski , in Power Query, select COD column, and select Unpivot others columns, like the image:
The result:
Best regards