Forum Discussion
Pussyk
Feb 13, 2021Copper Contributor
Transposing a table
Hello, I have a panel data table. The value of an item is recorded each year. The column has values corresponding to the year ( table 1). So, there are 11 years and 11 different columns. I want to ...
Wyn Hopkins
Feb 13, 2021MVP
Hi
The Power Query Unpivot Other Columns function is perfect for this
Apologies for the music choice https://youtu.be/2c06jmrAb3I
Wyn
MVP
UTC + 8
The Power Query Unpivot Other Columns function is perfect for this
Apologies for the music choice https://youtu.be/2c06jmrAb3I
Wyn
MVP
UTC + 8