Expand columns dynamically in Power Query (THE RIGHT WAY!) | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Check out the blog post★ https://exceloffthegrid.com/expand-co... ★ About this video ★ Expanding table columns is a common Power Query action. It even has its own icon. But, there is a problem lurking here. Clicking this expand data button hardcodes the column names into the M code. If new columns are added to the source at a later date they don't show up. So, in this video, we are looking at how to expand columns dynamically in Power Query, so that we can get all the data we want. 0:00 Introduction 0:37 The Problem 4:32 The solution: Expanding columns dynamically 12:04 Conclusion ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: / exceloffthegrid #MsExcel
Excel Power Query Tutorial - Grouping Tables of Data
Power Query Secrets - Simple tweaks is all it takes.
4 METHODS to Filter by a List in Power Query | Excel Off The Grid
Dynamically Expand All Columns from Multiple Tables in Power Query
30 Power Query Tricks Most Excel Users Don't Know
How to Rename Column Headings with Power Query - the quick automated way
These 5 Custom Column Tricks Make Power Query Easier
One Excel Formula. 9,000 Rows. One Thing to TRUST.
Power Query Convert Columns to Rows for groups and expand columns dynamically in 2 ways
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
8 Tiny Excel Symbols That Replace Messy Formulas
COMBINE FROM FOLDER in Power BI | What to do when new columns don't show?!
Convert Multiple Column Groups to Rows in Power Query
10 awesome Power Query tricks you NEED to know! | Excel Off The Grid
Power Query was HARD until I learned these 7 Tips
Drop‑Down Lists From Tables: Stop Using INDIRECT (Do This Instead)
Don’t Just Click Expand – Do This Instead
Fix your slow Power Query refresh from SharePoint (700% faster)
APQ04: Advanced Power Query Video #4 - M-CODE - Combine Inconsistent Tables
