Forum Discussion
Download and Combine Multiple files from multiple folder
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?
1 Reply
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.
