We are trying to sort data based on identification nos. from location A to B.

Example of data

Location A Location B
123 466
476 741
001 004
466 123


1st and 4th rows actually refers to the same thing. Is there a way to sort
this so that we can eliminate duplicates in "pairs" in data? Pls help...