Splitting a column by category into new columns

[zebrapineapple]

Hello everyone

Looking for a little help for something I thought would be easier!

I have data that I need to split a column out into new columns based on the catergories within.

Basic example shown below and how I need to turn it:

Now on a visual level I can get what I need with a matrix but I would like it available in a data table so I can add more calc columns and lookups to other things.

I've tried transpose and unpivot in Power Query but that doesnt work.
I've tried a summary table but i dont think you can split a column.

I'm going to try a summary table and a lookup to the original, see if that works.

If anyone has any ideas please let me know!

[Anonymous · Accepted solution]

Hi, 

Pivoting the table should give you the result you're after. 

Original Data

Pivoted Data

Select the category column in query editor and click on "Pivot Colum" and use "Value" column for values

[zebrapineapple]

Ahhh I was using un-pivot so I needed to do the opposite!
Confusingly I had already un-pivoted the data so I was trying to un-pivot it again - instead the data has now been un-pivoted now pivoted!

[PVO3]

Select the category column in PQ and use the pivot Column button