In a column, I have id pairs. Some of the pairs in the different rows are in reverse order, such as; "abc123 - xyz456" and "xyz456 - abc123". I need the column to be unique by detecting these kind of pairs are the same. How could i do that?
Please sign in to leave a comment.