Merging three outputs and stacking horizontally.

[Adam_B]

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

[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 · Accepted solution]

Hi @Adam_B 

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

Workflow:

Hope this helps : )

[Adam_B]

@atcodedog05 Amazing, that was perfect, thank you.

[atcodedog05]

Happy to help : ) @Adam_B 

Cheers and have a nice day!