Merging multiple excel sheet according to their header name.

[Ekmi9]

I have one folder which contain multiple excel files and each excel file have multiple sheet i want to merge that excel files according to sheet name and also header name. can somebody help me this issue ?

Thank you in advance! 

[atcodedog05]

Hi @Ekmi9 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[Ekmi9]

Below attached sample input and excepted output i have one folder that contain "N" multiple excel file which not fix every time.  

[atcodedog05]

Hi @Ekmi9 

can you provide this excel file attached.

[Ekmi9]

Yes 

[atcodedog05 · Accepted solution]

Hi @Ekmi9 

Here is how you can do it.

Workflow:

Hope this helps : )

[Ekmi9]

Can you please share the configuration of macro and i am getting this error while running this workflow.

[atcodedog05]

Hi @Ekmi9 

You can ignore those. These are not required assets. You can just take the macro and build the workflow in a similar way.

Hope this helps : )

[atcodedog05]

Happy to help : ) @Ekmi9 

Cheers and have a nice day!

[Ekmi9]

@atcodedog05 thank you :)