Showing A+B as same as B+A in the rows

[suraj_ford]

Hello Guys,

I have number of rows of data (representative purpose) as shown,

Col_1	Col_2	Value
A	B	0.45
B	A	0.45
A	C	0.87
B	C	0.34
C	B	0.34

And I want the output to consider A & B 0.45 to be same as B&A 0.45 and eliminate one of the row(preferably second.  i.e.  B & A. So the expected output would be like this.

Col_1	Col_2	Value
A	B	0.45
A	C	0.87
B	C	0.34

Please help, how to do this in Alteryx.

[Emil_Kos]

Hi @suraj_ford,

Thank you. Highly apreciated.

Good Luck!

[HomesickSurfer]

HI @suraj_ford 

My simplistic and efficient approach.  See below and attached.  Hope u like it!