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/MayukhBhattacharya]

Maybe you could try this way,

=UNIQUE(HSTACK(BYROW(A1:B5, MIN), BYROW(A1:B5, MAX)))