Combining excel sheets present in a folder

[Anasalter]

Hello Everyone,

I have 15-18 excel workbooks,

each workbook have a sheet named as ABC and all of these workbooks are present in a single folder.

No i want to combine or (append)  all the data from all the workbooks (sheet-ABC) into a single file 

problem is some files have let's say 30 columns some have 20 ,

data structure is not same.

how can i combine these files and how can i get data for each column in its position.

[alexnajm · Accepted solution]

The batch macro here should do the job! https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[alexnajm]

Just adjust the setting to output based on column position if that’s the preference

[Anasalter]

Thank You @alexnajm