How to Merge multiple Excel sheets with Power Query

Step 1: Format all sheets as a table (use CTRL + T)

Step 2: Go to Data > Get Data > From Other Sources > Blank Query

Step 3: Enter =Excel.CurrentWorkbook() on the Power Query formula bar

Step 4: On the Power Query home tab click “Load Data”

Watch Video on how to merge multiple sheets with Excel Power Query
Tell your friends about this page