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

[Chirag_KRCPL]

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

[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. 

[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 · Accepted solution]

Hey @Chirag_KRCPL,

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

Thanks & Regards,

Allwyn.

Spoiler

[Chirag_KRCPL · Accepted solution]

Hi @allwynthomas24 

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

[allwynthomas24]

Hey @Chirag_KRCPL,

Happy to see that the solution worked out for you. Thanks for marking it as the solution.

Regards,

Allwyn