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