Compile excel files with different number of columns

Help Studio
1

Hi, is there a way to compile excel files (with different number of columns & columns have duplicate names)?
If the same number of columns, and column names are unique, i can just append the datatable and fill in the excel. But for the above mentioned case, how can i go about it?

2

Hi @Username95, did u mean join different datatable?

3

hi, yes. For example, excel file 1 has 10 columns of data, 2 of the header names are same but different datas. And Excel file 2 has 8 columns of data, 2 of the header names are same but different datas.
So output should have 10 columns of data.