Suppose I have two Columns I want to check similiar records like this
Destination1 | Destination2 |
A | B |
A | D |
B | A |
B | C |
C | A |
C | B |
I would like to check similiar record from Destination1 <-> Destination2 like A->B and B->A is similiar I would like to filter it out
so the result would be like
Destination1 | Destination2 |
A | B |
A | D |
B | C |
C | A |
Is there any idea to clean the duplicated data out?
Thanks in advance
Solved! Go to Solution.
Thank you for idea
User | Count |
---|---|
17 | |
15 | |
15 | |
8 | |
5 |