★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post★
https://exceloffthegrid.com/expand-columns-dynamically-power-query/
★ 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: https://twitter.com/exceloffthegrid
#MsExcel