Forum Discussion
Turn rows into columns with Distinct
Hello, everyone 🙂 My table follows this structure: ID Level Code 111 D 53.1 111 K 75.1 222 H 82.1 333 G 75.1 333 G 82.1 I would like to create a new t...
Anonymous
In Power Query, Select LEVEL Column, go to Transform Tab and Click on Pivot Column.
In the Value Column, choose CODE, It will pivot as you expected________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Anonymous , You can pivot
https://radacad.com/pivot-and-unpivot-with-power-bi
OR You can use matrix visual, put id on row and level on column and code on value
Always more than one way to skin a cat!