Forum Discussion
Solved
Magic of Power Query-Getting column headers from multiple header rows with merged columns Power BI
In this NEW video, learn a technique to get table column headers when an Excel file has multiple header rows and also if header rows contain merged columns.
Also, in this video, we will explore various Power Query "M" List functions like List. Transform, List.Zip, get record from a table using record number, etc. This video gives you a flavor of writing "M" code in the advanced editor and shows the "M"agic of Power Query on how to solve the common data preparation challenges.
Power Query is Powerful - Magic of M language
