, 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
Solved! Go to Solution.
@Bakiyaraja wanted to check whether the given workflow working for you or not?
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.
@Bakiyaraja just checking whether the updated workflow working for you or not?
@ 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.
@Bakiyaraja @I’m really glad to know that the solution worked for you!!!