Forum Discussion

nmck86's avatar
nmck86
Post Patron
9 years ago
Solved

Moving Columns to Rows or Building Multiple relationships

Hi All, I have a data set and I am attaching a sample of that for everyone to see. I am wondering how I can get the data flipped from columns to rows for all the 2nd, 3rd, 4th, and 5th level designa...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi nmck86,

     

    In this scenario, you can use the Unpivot option in Query Editor to turns multiple column headers into a single column but in rows. and store their values in another column. For more details about how to use Unpivot option in Power BI, you can refer to this article. :smileyhappy:

     

    2016-04-07_01h04_27

     

    Regards