HELP to separate a column into multiple columns

[lennox25]

Hi,

Can anyone help please? I have a report which currently displays as this. What I need is for the categories A-G to be in columns of their own and within that column if there is a peformance outcome for it to show within that column.  I include the power bi report of how it looks now also.

https://drive.google.com/file/d/13EVmkQb8LJMDprpxmCZTqghN8CmrwukE/view?usp=sharing 

[DOLEARY85 · Accepted solution]

Hi,

In Power Query select the categories column, select Pivot Column from the Transform toolbar, in the Values column select Performance Outcome, in Advanced Options select Don't Aggregate.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[lennox25]

Thank you so much! I had been trying to pivit without much luck but the 'Don't aggregate' was the bit I missed! 🙂

[DOLEARY85]

No worries, happy to help 🙂