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