PQB04.5: Power Query Basics: Combine Data From a Folder Contains Excel Files Using Power Query
Channel: AAA Excel’s Power
Date: 2020-10-03

Hello and Welcome, we continue with POQ or Power Query Basics.
This video is demonstrating how to combine data from a folder contains Excel Files using Power Query then perform and automated required data transformation, so when you add more files to the folder, it automatically flows to your final report.
Method #1: Use "Combine Files" button 3:34
Method #2: Use "Excel.Workbook" function 7:55
The previous video was PQB16 and supposed to be the last video of PQB series, however, I received inquiries from some colleagues who watched video PQB04 (basically discussing combining files from a folder contains CSV files) and tired to apply the same technique to consolidate data from a folder contains Excel Workbooks but it didn't work. Accordingly I decided to add this topic to PQB series to cater for this requirement.

To watch video PQB04:
https://youtu.be/0WkS7Ojp6us

To watch the full playlist 
https://www.youtube.com/playlist?list=PL5NlUYOM2iOhZOJL_GM6zNd2k9-IEqmaV

To download the excel working file, data & additional data files:
https://drive.google.com/drive/folders/15wkYNbSD3ML8-en_PAMNnu8WOhXZ6pkJ?usp=sharing

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef