Combine Data from Multiple Workbooks in a Folder Using Microsoft Excel's Power Query

In this Microsoft Excel video tutorial I demonstrate how to combine multiple workbooks (stored in the same folder) in a single workbook. The method shown in this video uses Power Query.

Table of Contents:

00:00 - Introduction
00:15 - Create a 'From Folder' query in Power Query
00:37 - Exclude non-Excel files.
01:47 - Apply data transformations
05:47 - Edit the query
06:18 - Add more workbooks to folder and update data in the combined file
------------------------

[IvanCortinas_ES]

Transform Sample File is an important step!! Thank you for this explanation, that's very useful Chester!!!

[teoxengineer]

Lets assume that there are some nonadjusted column names with diffrent workbook. What will we do?