⏬ This Power Query Challenge is about combining multiple records into single rows ⏬
00:00 Intro
00:19 The Challenge
01:44 The Long Solution
05:44 The Better Solution
The Solution File and everyone's submissions can be found here:
https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/ErJaOpJKIm1NhjPENOyiDwABX1sGPwcJWcq0EuSZelx5kA?e=BYyE7P
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/