Download and Combine Multiple files from multiple folder

[Anonymous]

Dear Members,

I have 5 different folders with atleast 10 files in each folder. Files represent different countries and folder is for different year. I would like to combine all of these files to look in below format 

S.no	Country	Product	2002	2003	2004	2005
1.	India	Meet	20	30	40	30
2.	US	Cloths	223	342	3422	3432

My folder looks like below,

Folder Name	Files Names	File content
2002	US	Products
2002	India	Products
2003	US	Product
2003	India	product

Is it possible to uploaded these folders in single Querry or do i have to create seprate querry for each folder and then create relationship? 

[Ashish_Mathur]

Hi,

Place all files in a single folder and follow the steps outlined in this video (Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube) to append data from all files in that single folder.