Promote headers in nested tables before expanding columns | Power Query | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Get the example file ★
https://exceloffthegrid.com/promote-h...
★ Check out the dynamic column expand post ★
https://exceloffthegrid.com/expand-co...
★ About this video ★
In Power Query, promoting headers of nested tables before expanding columns leads to fewer and easier transformations. However, these options are not available in the user interface. Therefore, we need to make a few changes to the M code ourselves.
This video shows two ways to promote headers before expanding the columns.
0:00 Introduction
0:25 Example & problem
2:30 Promote nested Table headers - Excel files
3:34 Promote nested Table headers - Other file types
6:50 Dynamic column expand method
7:19 Wrap-up
★ 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