Power Query Convert Columns to Rows for groups and expand columns dynamically in 2 ways

Описание: 🔽More Information below🔽

This Power Query challenge uses GroupBy, List functions and a little hack

There's also a trap with expanding the columns if the number of columns may change. I show 2 ways of doing that.

Thanks to everyone for taking part. You can download the challenge file if you want to try this out, and also my solution (and everyone elses) is available here too
https://accessanalytic.com.au/power-q...

I love reading your comments and questions so feel free to post those

Here's a link to the my video of a 3rd solution:    • Power Query Pivot and adding an Index colu...  

Thanks to these folks for taking part, solutions are saved in the same folder as per the link above
Alexander Sorokopyt
Andrew Shepley
Bohdan Duda
Chandeep Chhabra
Christopher Hazel
Daniil Maslyuk
Daryl Lynch
Diana Maria Iordachescu
Dyota
Glyn Willis
Guido
Henriette
Ivan Dumalovski Janjušić
Jan Berny
Kolyu
Leon Dijkers (winner of the first person to submit a solution award 😀 )
Nick Bonner
Nizam
Peter Tholstrup
Philip Treacy
Quadri Atharu
Sham F
Steve Bateman

Follow me on various platforms: https://wyn.bio.link/

Cheers

Wyn