Transpose rows to colums

[davidgray42]

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

[Einomi]

Thanks @davidgray42 it is pleasure to help 🙂

[Einomi · Accepted solution]

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 🙂

[davidgray42]

Wow, it was that staightforward 😁 

Thanks for your answer, works a treat now 👍