Forum Discussion
Resolver IGrouping same IDs and creating new columns from their respective values
Hi ddalton ,
How about pivoting in Power Query:
All you need to do is marking the Code column (left click), choose the transform ribbon, click on pivot column, select Value as Value Column and click ok:
Let me know if this helps or if you get stuck soemwhere 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Most Valuable ProfessionalHi ddalton ,
How about pivoting in Power Query:
All you need to do is marking the Code column (left click), choose the transform ribbon, click on pivot column, select Value as Value Column and click ok:
Let me know if this helps or if you get stuck soemwhere 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Resolver IHi tackytechtom,
Thanks for suggestion - that's definitely the trick for it. It was something I'd been playing around with but kept getting errors with I've managed to resolve now (null/blank values etc.)