Combined Excel Files using Power Query

Steps to combined multiple file using power query.

To start the process of combining multiple files, first ensure that all the files you want to combine are contained in a single file folder.

Click on the Data Tab -> From File -> From Folder

Click on the browse button to select MS Excel files from folder.

We can select folder which contains MS Excel files. Then Click on the OK button.

Click on the combined button to combined the file.

Select Sheet 1 -> OK

Here we can select OK Button to finally consolidate the sheet.

Finally we got the consolidated sheet.