Forum Discussion
Solved
Pivot or Group
Hi all I have a data set that I need to Change the structure and format Any suggestions to reformat this data? Desired Outcome is FORM ID Date out DateIn ReceivalNo ID Name Location...
Hello Babycakes_00
In Power Query you can follow this simple steps to get the table stucture you want.
- Select the FORM ID and Name columns.
- Go to the Transform tab and click on Pivot Column.
- Use Value as the "Values Column."
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Hey!
This can be achieved by using the pivot function in Power query.
To achieve this, first remove the column that makes every row unique ( [ EntryID]).
Secondly use Table.Pivot on the name and value columns. Selecting Don't aggregate in the advanced options.
Codesnippet:
let
Source = YOURTABLE,
#"Removed Columns" = Table.RemoveColumns(Source,{"EntryID"}),
#"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Name]), "Name", "Value")
in
#"Pivoted Column"