Log In
Register
Home
March 21, 2023
Offline
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
October 5, 2010
Offline
hi Paul,
No file attached. Click Start Upload after selecting the file.
regards
Phil
July 16, 2010
Offline
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
March 21, 2023
Offline
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
Trusted Members
Moderators
November 1, 2018
Offline
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.
1 Guest(s)
