Identical items on one column to another column, place it one under the other

[DanielCarro]

Hi,

I have a query which I am not sure if this can be done on Alteryx

I have two columns

ID 1	ID2
TRE002227	X1
TRE002229	AD2
TRE002231	RR24
TRE002235	TEW333
XWQ1	TRE002224
DD45	TRE002229
DDR456	TRE002230
TDD	TRE002231

The result I expect is the following:

ID 1	ID2
TRE002227	X1
TRE002229	AD2
DD45	TRE002229
DDR456	TRE002230
TRE002231	RR24
TDD	TRE002231
TRE002235	TEW333

Kind Regards,

Dan

[FrederikE]

Hey @DanielCarro,

I would use smth. like a transpose and then a unique Tool after it. See the attached WF (Solution is not exactly as yours as I don't understand it completely, but this should help you do it). 

[DanielCarro]

Hi Frederik,

The objective is that the number in col ID1 and the same number in ID2 should be directly underneath. As per the example

TRE002229	AD2
DD45	TRE002229

[ArtApa]

Hi @DanielCarro - Here is a possible solution. I don't understand why the row DDR456 in your expected outcome moved up though.