Col A Col B
AV123 GG987
FG145 BB488
GG987 AV123
KL489 LL778
Here Row1 and Row 3 are basically pairs with swapped values between them. I need to delete only one of them (either 1 or 3). So the Resultant table will be
Col A Col B
FG145 BB488
GG987 AV123
KL489 LL778
OR
Col A Col B
AV123 GG987
FG145 BB488
KL489 LL778
How to do this ? Can anyone please suggest anything on this subject?