How to Union three Columns

[lacubata]

Hello everybody, i am having trouble joining three columns and i don't know what else to do. I have three different columns generated by alteryx, Example:

DATA A

1

2

3

4

5

DATA B

8

123

43

DATA C

32

4

If i use the union tool the output is this one:

DATA A	DATA B	DATA C
1
2
3
4
5
	8
	123
	43
		32
		4

And i need this one:

DATA A	DATA B	DATA C
1	8	32
2	123	4
3	43
4
5

Maybe it is a stupid question, but i have tried a lot of options unsuccessfully.

Thank you so much for your help!!

[Kenda]

@lacubata I would suggest adding a Record ID tool after each of your three inputs. Then use a Join Multiple tool using the RecordID field to Join by Specific Fields.

[danrh · Accepted solution]

You can also use the "Join by Record Position" in the Join Multiple tool:

[lacubata]

Thank you so much! As i thought it was an easy one... I tried to use the record ID but my mystake was to use the simple join, so a lot of records were out.

Thank you again!