Consolidate multiple workbooks (csv-s)

[apoje]

I have a problem which I do not know how to solve it.

I would like to combine 100+ csv files into one. All of the files have the same structure. I would use a consolidate function, but there you have to specify the range of each workbook which is not accaptable solution in the case of multiple files. Also I am not sure if consolidate option is even the right one, since the I would like to preserve all the rows from the files.

In the attachment I am posting 4 workbooks for example. I would like to get all the data into one.

Thank you for the help!
Andraž

[sandy666]

something like this one?

[avk]

Hopeful below link help you.

[apoje]

yes that is the desired result

what are the steps?

[sandy666]

use @ to identify to whom you are talking

try PowerQuery (Get&Transform) - this is built-in feature in Ex2016/365

use single sheet workbook
Data - New Query - From File - From Folder and after open , load to the sheet then save result as CSV

[sandy666]

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.