I have a 2-column table, one column is labeled Headings and the other Values.
I am trying to move the 5 unique references in the Heading column into 5 separate columns and the data in the Values column moved under the appropriate heading.
Attached I have added a sample.
Thanks
P
hi Paul,
No file attached. Click Start Upload after selecting the file.
regards
Phil
Sounds like you need to Pivot the data. Select the Heading column > Transform tab > Pivot Column. Select the Values column from the drop down and under Advanced Options, select 'don't aggregate'.
If that's not what you need, then please upload the example file showing before and after examples.
Mynda
Hi Mynda
Thanks for your reply, see attached the file - sorry I thought I had attached in the original post.
The pivot worked however it returned an error, see attached the original sample and error
Thanks
Paul
Specify an action for the values column (eg Sum). The formula should look like:
= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Headings]), "Headings", "Values", List.Sum)
for example.
