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
 
					
				
				
			
		
