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