Using the List technique in Power Query to recombine tables @AccessAnalyticLearn
Using the List technique in Power Query to recombine tables  @AccessAnalyticLearn
Uploaded August 2024 | Updated September 2026, 1 week ago
The M code can be tricky to get your head around but it sure can often reduce the amount of steps needed to achieve your goal vs using the User Interface buttons.

Download the file here
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EkpLzHrrogtAoAlErGpZW_gBtrzMQdlzI8ggKg-ykWZwWw?e=nEF7rN


Prior Video Solution using button clicks
youtu.be/e9y4hOFQPgc



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
Using the List technique in Power Query to recombine tablesIs it really Excels fault?Why Microsoft PowerToys Is the Best Free Tool You’re Not Using!Excel Table Traps: Avoid Common Excel Pitfalls with These Tips!Power Query Online Trick: Import Without “From Table/Range”Agent Mode in Excel Labs: It Finally Works!  Fix + DemoWhat are DAX User Defined Functions UDF in Power BIWhy you should never hide columnsThe crazy trick to giving External Users access to Power BI reports and workspacesFull Power Query Editor in Excel for Web!!Remove Blanks with TOCOLNEW!  Power BI Now with Auto Refresh in PowerPoint
Access Analytic Learn |

Using the List technique in Power Query to recombine tables

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER