The quickest way to find out discrepancies between two columns

[187]

I have data set like below

ID	COL A	COL B
1	AAA	BBB
2	BBB	CCC
3	CCC	ZZZ
4	DDD	FFF

I want the delete the line that if COL A value exist in COL B or  COL B value exist in COL A

so for ID 1  BBB existed in Col A  so it is deleted. for ID 2 BBB existed in COL B deleted. ID 3 CCC existed in Col B so it is deleted.

the result i want is only  

4

DDD

FFF

what is the quickest way to implement this?

[Qiu]

@187 
Not sure it is the fastest but it should work. 

[187]

Thanks for your quick solution, what if the first column ID is not unique? i saw you use join here 

[AZuc]

@187 

If ID is not Unique then add a Record ID tool before Transposing and use this key in the final join.

[AZuc]

@187 

I've built this approach here to practice a little bit on Make Group tool. I'm not sure how it will work with more data. It needs further testing.