Uploaded January 2025 | Updated November 2026, 1 day ago
Download the file here:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/ElUqvNCkiUlNueLk-M8NhjgBIz2gj-YGlxBe8H5hD-chTw?e=wDGgve
In this Power Query challenge, you'll learn two dynamic methods to split and restructure data efficiently. The video demonstrates a step-by-step guide using a hands-on approach with manual unpivoting, merging, and splitting columns. Alternatively, you’ll see a more advanced and elegant method involving custom M-code using lists of records. The first method focuses on merging columns with delimiters, unpivoting, and splitting them back into a clean structure. Meanwhile, the second method leverages Power Query’s ability to create custom records and expand them effortlessly. Whether you're a Power Query beginner or an advanced user, these techniques will streamline your data preparation workflows.
By the end of this tutorial, you'll understand how to transform datasets with ease and confidence, opening the door to faster and more automated solutions. Don’t miss out on this challenge—mastering these techniques can drastically improve your efficiency in data manipulation tasks.
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
wyn.bio.link
Download the file here:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/ElUqvNCkiUlNueLk-M8NhjgBIz2gj-YGlxBe8H5hD-chTw?e=wDGgve
In this Power Query challenge, you'll learn two dynamic methods to split and restructure data efficiently. The video demonstrates a step-by-step guide using a hands-on approach with manual unpivoting, merging, and splitting columns. Alternatively, you’ll see a more advanced and elegant method involving custom M-code using lists of records. The first method focuses on merging columns with delimiters, unpivoting, and splitting them back into a clean structure. Meanwhile, the second method leverages Power Query’s ability to create custom records and expand them effortlessly. Whether you're a Power Query beginner or an advanced user, these techniques will streamline your data preparation workflows.
By the end of this tutorial, you'll understand how to transform datasets with ease and confidence, opening the door to faster and more automated solutions. Don’t miss out on this challenge—mastering these techniques can drastically improve your efficiency in data manipulation tasks.
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
wyn.bio.link










