How to combine spreadsheets from different folders inside another folder

[Anonymous]

Hello to evereryone, I am trying to model the data for a new dashboard and don't now how to combine some csv files from different folders.

I have a master folder with the following folders inside(each week another folder is created inside the master folder):

And inside of each of the folders I have 6 csv files. I would like to combine the corresponding files between folders.

For example, I need to combine the driver_activity csv of the current 10 folders in the master folder.

Is it possible to get this thing done with power query?

Thanks in advance.

[sevenhills · Accepted solution]

Yes, you can do that ... 
a) Get data

b) Select the master folder

c) The query gives all the list, filter for .csv files

d) Combine the files data, by clicking the content column 

...  continue the remaining steps