Check out our newly launched M Language course ↗ https://goodly.co.in/learnmpowerquery/

In this video you'll learn to combine data from multiple excel files into a single sheet using Power Query. In this case I am assuming that your data structure will be the same

You can watch Part 2 (for combining uneven data)    • Combine Data from Multiple Excel File...  
New video for handling multiple sheets and multiple columns in a dynamic way    • Combine Data From Multiple Excel File...  
The full blog post can be found here https://www.goodly.co.in/mergedataf...

My Courses
✔ Mastering DAX in Power BI
https://goodly.co.in/learndaxpowerbi/

✔ Power Query Course
https://goodly.co.in/learnpowerquery/

✔ Master Excel Step by Step
https://goodly.co.in/learnexcel/

✔ Business Intelligence Dashboards
https://goodly.co.in/learnexceldash...

Blog
https://www.goodly.co.in/blog