Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to pivot (or sort) data into four columns with headers from a column with 4 repeating values.

Hello community,   I spent a month on the intermediate to advanced tutorials and have been lurking in the forums for a couple weeks and cannot find the answer after fiddling around.   Data is par...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
4 years ago

 

Hello Jay,

 

Here is an example (though in excel) of how I need to transform the data in PowerBI. Taking each repeated set of four output values and transposing them under 4 column headers (Column 1.1 is only transposed once as a header).

 

I don't know how to cut out this manual Excel transposition and looking to see how PowerBI would do it directly.

 

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Jay what you certainly did works. To be honest, I stared at this for over 15 minutes so I'm going to ask for help or a better print guide than the link below to perform the "filtered rows" step.

      Filter by values in a column - Power Query | Microsoft Docs

      I see that you did apply the filter to break it up into different tables. I see that works. It looks like there are multiple ways to solve this problem and would like to learn these functions.

       

       

      1st step stuck on:

       

      How do I pull up this dialog box from scratch (not editing yours)?

       

       



      Thank you for your patience. 

      Best Regards,

       

      Brendan