Forum Discussion

davidgray42's avatar
davidgray42
Frequent Visitor
2 years ago
Solved

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

  • 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's avatar
      davidgray42
      Frequent Visitor

      Wow, it was that staightforward 😁 

       

      Thanks for your answer, works a treat now 👍