Merging two outputs into one ouput data (excel file)

Question

Hello,

I have two different rows of data which have exactly the same header. How do I merge them into one output which contains both rows.

Data 1:

timecostresource account number1234

Data 2:

timecostresource account number3456

I want to get here (Merged data):

timecostresource account number12343456

Thanks in advance

atcodedog05 · Answer

Hi @Armansson ,

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

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

Union.yxmd

Armansson · Answer

Hello,

Thanks for you reply.

is there any way to separate the merged data in following way?  (I want the merged data to be separated under different headers in the same sheet, the header can be the name of incoming data into union tool, as below)

timeCost resource account number    #1   1234    #2   3456

grazitti_sapna · Answer

Hi @Armansson , with the help of union tool you can achieve the desired result.

Thanks.