Forum Discussion
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...
Hi Anonymous ,
Please take a look at the pbix file.
Best Regards,
Jay
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