🔽More Information below🔽
Here's a link to the previous 2 solutions to this challenge: • Power Query Convert Columns to Rows f...
This Power Query challenge solution uses GroupBy, Table.AddIndexColumn and Pivot
Thanks to everyone for taking part. You can download the challenge file and solution here:
https://accessanalytic.com.au/power-q...
I love reading your comments and questions so feel free to post those
Thanks to these folks for taking part, everyone's submitted solutions are saved in the same folder as the solution file.
Follow me on various platforms: https://wyn.bio.link/
Cheers
Wyn