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
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