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
Hi Babycakes_00
Dod the solutions dharmendars007 , Chewdata and tackytechtom offered help you solve the problem, if them help, you can consider to accept them as solutions so that more user can refer to, or if you have other problems, you can offer some information so that can provide more suggestion for you.
Best Regards!
Yolo Zhu