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
