In this guide, I show you how to combine Excel files in Power Query, starting from simple setups and moving and moving to real life messy files. I’ll walk you through Level 1, where all the files are clean and easy to merge, and Level 2, where we fix the common problem of different sheet names. Finally, we tackle Level 3, where all hell breaks loose and the data structure is different in every file. I’ll show you how to create and use a Custom Function to clean each file automatically before they are joined together, so you can handle even the most frustrating data tasks without doing the work manually.
