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    ...
Need Help
  • Einomi's avatar
    Einomi
    2 years ago

    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 🙂

Einomi's avatar
Einomi
Helper V
2 years ago

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
    2 years ago

    Wow, it was that staightforward 😁 

     

    Thanks for your answer, works a treat now 👍