Hi,

I currently have **two columns** with all the possible combinations from the values of a single category:

Column 1 | Column 2

A | B

A | C

B | A

B | C

C | A

C | B

As you can see, those combinations are not exactly “unique” if we consider that **A | B** is the same as **B | A**. I can’t find a way to filter those columns based on unique combinations… any ideas?

My best chance is to create a new column with a concatenation in alphabetical order, so, I would have:

Column 1 | Column 2 | Column 3

A | B | AB

A | C | AC

B | A | AB

B | C | BC

C | A | AC

C | B | BC

With this method would be very easy to remove duplicates. But can’t find a way to concatenate columns based on the alphabetical order.

Any ideas?