Merge multiple csv files with the same file name into one csv

[chocoprince]

Dear Expert,

Let's say i have the below files in two folders:

Folder 1:
ex1.csv
ex2.csv
ex3.csv
ex4.csv
ex5.csv
ex6.csv
....

Folder 2:
ex1.csv
ex2.csv
ex3.csv
ex4.csv
ex5.csv
ex6.csv
....

Folder 3:
The final sheet should be saved here

Can someone tell me how I can merge ex1.csv from "folder 1" with ex1.csv from "folder 2" and save it under the name ex1.csv in "folder 3"?4
Also can I remove the first row of ex1.csv in folder 2 so I don't have two headers?

I have 3000 files that are duplicated twice.

Thank you

[MarvinP]

Hi chocoprince and welcome to the forum,

In the newer versions of Excel there is a tool called Power Query or Get & Transform that has the ability to do your problem. Here are two sites that go step by step through the process:
https://support.office.com/en-us/art...8-6a00041c90e4
https://exceleratorbi.com.au/combine...s-power-query/

[Marc L]

Can someone tell me how I can merge ex1.csv from "folder 1" with ex1.csv from "folder 2" and save it under the name ex1.csv in "folder 3"?4
Also can I remove the first row of ex1.csv in folder 2 so I don't have two headers?

Copy all files from Folder1 to Folder3 then for each file in Folder3
if exists the same name file in Folder2 (see VBA Dir function)
so open the file in Folder3 in Append mode (see the VBA Open statement) and open the file in Folder2 in Input mode
then read each line from Folder2 file and write it to the Folder3 file (like you can see in the VBA help examples) …

For further help post at least some source files and expected result files with the appropriate technical explanation
in order any helper has all the necessary without anything to guess
or you must be very confident with your Excel / VBA skills to amend any code !