Combing Excel Files with Different Number of Fields

[CBA]

Hi, I am looking to combine a folder of 20+ excel files that have slightly different number of fields. I tried using a wildcard, but since the first file has 20 fields and the third file has 21 fields, that third file doesn't get aggregated.

What tool should I be using to combine these files so that I get one aggregated file with the max number of fields (and for the files without those fields it displays a blank)?

Also, is there a logic I can put in place to remove a row based on the content in the leftmost column? As an example, each file has a "Total" row that I don't need.

Thanks!

[mceleavey · Accepted solution]

Hi @CBA ,

I've attached an example workflow and the macros you need. 

This will load in all sheets from all workbooks.

Save the .yxmc files in your macro folder then open the workflow.

I hope this helps,

M.

[CBA]

@mceleavey, this is perfect, and then I will incorporate some logic to clean up this aggregated file. 

Really helpful, I appreciate it!

[mceleavey]

You're very welcome. Glad I could help.

M.