Data input

[Bakiyaraja]

, I am looking for solution for below problem I have 5 excel files that are all different in structure/schema • 2 files have 10 column, • 1 file have 8 column • 1 have 16 column • 1 have 4 column and I need to merge in single excel with five different sheets could you please help me or share sample workflow it would be helpful

[binuacs]

@Bakiyaraja wanted to check whether the given workflow working for  you or not?

[Bakiyaraja]

 HI Binuacs ,Thanks for follow up  YOU REACHED ALMOST 90 % the but problem still exist in the workflow , if the number is column in the sheet is different /or when we gave 3 input with different schema.

please find the output after macro 2 :

i am still looking but not able to solved,could you please help to solve 100% 

Please find the attached input sheet.

[binuacs]

@Bakiyaraja Can you try the attached workflow and let me know

[binuacs · Accepted solution]

@Bakiyaraja just checking whether the updated workflow working for you or not?

[Bakiyaraja]

@ Binuacs Thank you for everything you do. The solution you provide help me to solve the problem.

 You have been most helpful. You have my gratitude.

[binuacs]

@Bakiyaraja @I’m really glad to know that the solution worked for you!!!