Combine multiple worksheets with different number of columns

Question

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!

AkimasaKajitani · Accepted Answer

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

data1

data2

result

atcodedog05 · Accepted Answer

Hi @cruzalexei06

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

Input:

Output:

Workflow:

Hope this helps 🙂

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