Part 1 - Imported Data is Stacked
"I have multiple CSV files in the same folder. How can i merge all the CSV files into a single sheet?
Even better would be an added column so the source CSV file name is included in the final data"
Part 2 - Imported Data is side by side imported into adjacent columns
"How can i merge all the CSV files in a folder into a single sheet? The data should go in adjacent columns, it's usually the same few columns.
Even better would be an added row at the top so the source CSV file name is included in the final data."
Nothing says "thanks" like a steak dinner!