Merging three outputs and stacking horizontally.

Hello,

I previously needed help transposing data which helped, however, now that I have correctly transposed, I need to merge the 3 outputs to one in what I thought was a union, however, it's not right. I have this as my set:

The output, as you can surmise is stacked, I need it horizontally like this:

Supplier	Column A	Column B	Column C
Supplier A	Is Small	X	I
Supplier A	Is Little	X	I
Supplier B	Is Large	Y	J
Supplier B	Is Medium	Y	J
Supplier C	Is Medium	Z	K
Supplier C	Is Tiny	Z	K
Supplier D	Is Small	A	L
Supplier D	Is Large	A	L
Supplier D	Is Medium	A	M

Datasets

Reporting

Best Practices

Join

Accepted answers

atcodedog05

Hi @Adam_B

Here is how you can do it. You can use join multiple tool and join on position.

Workflow:

Hope this helps : )

join horizontal.yxmd

All comments

atcodedog05

Hi @Adam_B

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 : )

jonnyrask

Unless I am misunderstanding you, you need to use a Join. Join the records on the Supplier.

If you could send the workflow and some sample data your question would make more sense.

Adam_B

My apologies, here is the data

Data Set 1
Supplier	Column A
Supplier A	Is Small
Supplier A	Is Little
Supplier B	Is Large
Supplier B	Is Medium
Supplier C	Is Medium
Supplier C	Is Tiny
Supplier D	Is Small
Supplier D	Is Large
Supplier D	Is Medium

Data Set 2
Supplier	Column A
Supplier A	X
Supplier A	X
Supplier B	Y
Supplier B	Y
Supplier C	Z
Supplier C	Z
Supplier D	A
Supplier D	A
Supplier D	A

Data Set 3
Supplier	Column A
Supplier A	I
Supplier A	I
Supplier B	J
Supplier B	J
Supplier C	K
Supplier C	K
Supplier D	L
Supplier D	L
Supplier D	M

atcodedog05

Hi @Adam_B

Here is how you can do it. You can use join multiple tool and join on position.

Workflow:

Hope this helps : )

join horizontal.yxmd

Adam_B

@atcodedog05 Amazing, that was perfect, thank you.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280