Combining multiple tabs of single excel file having different number of columns

I am looking to combine 2 excel tabs of same excel file using SINGLE input data tool (I don't want to use multiple input data tools).

Tab 1 - "Demographic"

Tab 2 - ID Proof

This is the output that I am expecting:

Is there any way to combine these 2 excel tabs into one using SINGLE INPUT DATA tool (maybe via macro) ??
I have attached the excel file as well

Regards,
Chirag

Test File.xlsx

Batch Macro

Dynamic Processing

Accepted answers

allwynthomas24

Hey @Chirag_KRCPL,

Kindly check the attached workflow and confirm whether it matches your mentioned requirements.

Thanks & Regards,

Allwyn.

Spoiler

Combine 2 Excel Files - Chirag_KRCPL.yxzp

Chirag_KRCPL

Hi @allwynthomas24

Many thanks for this! It has helped me served my purpose.

All comments

Kurohits

Hi @Chirag_KRCPL

Use this macro that can easily consolidate multiple tabs or multiple sheets with different schemas. This is multi-purpose macro which can help to deal with any kind of structure or unstructured data.

Utility.yxzp

Chirag_KRCPL

Hi @Kurohits

Many thanks for the solution. I tried running the macro but it is showing following error:

I think this is because of the "DRS_02" excel file which has been been used for creating this macro. Can you please suggest what corrective action do I need to take in order to make this macro functional at my end?

allwynthomas24

Hey @Chirag_KRCPL,

Kindly check the attached workflow and confirm whether it matches your mentioned requirements.

Thanks & Regards,

Allwyn.

Spoiler

Combine 2 Excel Files - Chirag_KRCPL.yxzp

Chirag_KRCPL

Hi @allwynthomas24

Many thanks for this! It has helped me served my purpose.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703