Power Query - Combine Files with inconsistent column names! 😎🍔

In this video i show you how to cater for this common use case where you want to combine various files into one but all of the files have different column names. This video you'll learn how to define the destination columns and remove the ones you don't need.😎🍔
#data #dataconsistency #dataanalysis #dataanalytics #powerquery #powerbi #excel #mquery

File used in video
https://github.com/jbotes/powerbiTuto...

Source Files
https://github.com/jbotes/powerbiTuto...
https://github.com/jbotes/powerbiTuto...
https://github.com/jbotes/powerbiTuto...

Functions used:
Table.TransformColumns
Table.PromoteHeaders
Excel.Workbook
Table.Combine
Value.Metadata
Meta
Table.RenameColumns
List.Distinct
List.Transform
Table.selectrows
Table.ToRows

Noteworthy
1 - Using Meta to refer to a step in another query