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-query-challenge-columns-to-rows/ 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: https://youtu.be/o7Hs8JpswDA 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