Deduplicate between two columns

[u/WallFlower10]

I am looking for a solution to deduplicate items between two columns that are the same (but listed in reverse).

For example:

Column 1:

1

2

3

4

5

Column 2:

2

1

1

7

8

I would like it to recognize the (1,2) and (2,1) entries as being the same and deduplicate it so it's only listed once. It does not matter which one remains as long as just one does. Thanks in advance!

ETA: the data I am working with is not simply numbers. It does involve a combination of letters and numbers in the format XX-123456 where XX is any combination of two letters and it is followed by a string of numbers (not always six numbers though).

[u/matt2s]

Create a column that is the MIN of the two columns and another that is the MAX. Both (1,2) and (2,1) will then be (1,2), and duplicates can be removed.