Hey everyone, I have multiple CSV files with data in it. The files have the same headers like "email" or "ID" but they are not on the same position in every file. For example I have two files A and B with this tables ->
A:
email, ID, name, fullname
B:
fullname, ID, name, email
I now want to merge the data from the two files in one sheet but if I simply paste the I get wrong data in the columns e.g. for the first column in A and B I would combine email with fullname which is wrong.
How can I merge the data together by matching the same headers? I need to do this automatically, because I have 8 .csv files with 50 different columns each.
Please help me!
Bookmarks