How do I merge multiple smaller single sheet Excel-files with different columns into one large E...
So I have a list (around 10 items) of several single sheet Excel files with data inside. Most of the columns in these files are the same, but for each file there are 3 to 5 columns that change. So columns vary somewhat from file to file.
I want to merge these files into one larger Excel workbook, where each of the initial files is a sheet. It would be ideal to have the file names of the initial Excel files as sheet names.
I have tried several other methods that have already been suggested, but they don’t seem to be able to work with files with different columns.
Can someone suggest me a way to tackle this issue?