Combine multiple worksheets with different number of columns

[cruzalexei06]

Hi All,

Is there a way that I can consolidate multiple excel files all with 1 sheet but different number of columns? 

My goal is to merge all of this and align them based on their fields (Comp_id, comp_name, currency, balance). So output would look like this:

Would appreciate any help. Thanks!

[Jean-Balteryx]

Hi @cruzalexei06 ,

Are you able to provide input files ?

Cheers,

Jean-Baptiste

[AkimasaKajitani · Accepted solution]

If the all data is exist, the below workflow will work.

data1

data2

result

[atcodedog05 · Accepted solution]

Hi @cruzalexei06 

Here is a workflow for the task. A variation in approach.

Input:

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍