Combine Data from Multiple Excel Files in a Single Excel Sheet - Part 1

Published: 27 June 2018
on channel: Goodly
375,704
3k

Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/

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/merge-data-f...

- - - My Courses - - - -
✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/

✔️ Power Query Course-
https://goodly.co.in/learn-power-query/

✔️ Master Excel Step by Step-
https://goodly.co.in/learn-excel/

✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dash...

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