Forum Discussion
Transpose rows to colums
Hi,
In PowerBI / Power query I'm looking to convert a single row of data to columns with the header row used as column one. The example below is just a mockup in Excel.
Original
Desired output
In the Powerquery editor I have used Transpose to turn my row(s) into column(s), howerver when I display in a table in PBI desktop the data is converted back to rows. What is the easiest way to acheive this?
My dataset will contain multiple rows but only one can be displayed as I'm filtering on a single row slicer. I can enforce a single row to be returned by the SQL server if that makes it easier to display as a vertical list?
Powerquery
PBI desktop in a table control
Thanks in advance
Hi davidgray42
Load your table to Power Query
Select all columns then, on the Transform Tab > Unpivot all columns
Kudos and Accept as solution appreciated 🙂
3 Replies
- EinomiHelper V
Hi davidgray42
Load your table to Power Query
Select all columns then, on the Transform Tab > Unpivot all columns
Kudos and Accept as solution appreciated 🙂
- davidgray42Frequent Visitor
Wow, it was that staightforward 😁
Thanks for your answer, works a treat now 👍
- EinomiHelper V
Thanks davidgray42 it is pleasure to help 🙂