I have multiple .csv files in a folder. I'd like to combine data from those .csv files into one .csv file based on the headers in row 1 of my spreadsheet.
For example, If row 1 has headers in col a, b, c = Car, Truck, Van. I would like to combine all the data from fields Car, Truck, Van, for all the .csv files into 1 csv file. Any ideas???
Thank you.
Bookmarks