Uploaded May 2025 | Updated September 2026, 2 weeks ago

---

00:00 Introduction to the aaUNPIVOT function
01:27 Customizing Parameters and Handling Blanks
03:15 Python Alternative
05:43 Power Query Method Step-by-Step
07:15 How I built UNPIVOT


Download File: aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/Eo0xwnYp2khCveHOHESeup0BIqmuEHncYpXgps5i9I5rYg?e=htV8X6

Python GPT: chatgpt.com/g/g-5GwJLCdLp-access-analytic-excel-python-assist

LAMBDA GPT: chatgpt.com/g/g-XQJo0OSlz-lambda-guide

UNPIVOT GIST: gist.github.com/wynhopkins/b0c1418c2b220fb2a970eb796ee4ac42

Full GIST: gist.github.com/wynhopkins/2efdf218ed78be03a0a082ff6a99dad1




🧑🏻‍🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com

📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/

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/


🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join