How to combine multiple Excel files using Power Query?

Using Power Query to combine files. Some of you may already know Power Query’s “Get data from Folder” feature. This helps us easily get & combine multiple excel files in a folder. Unfortunately, this alone will not be helpful for us as our file has two different tabs and we need to combine them separately.
For More Information Please Refer:

You May Also Like to Read: