Forum Discussion
Splitting a column by category into new columns
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...
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
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
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!