List combinations of a range
I need a formula to find the actual combinations in a 2-column, 50-row range.
Both columns are constrained to 10 text characters if that makes it easier.
e.g.
Data: (may be in random order)
A A
A B
B A
B B
B C
B C
B B
J A
J A
Looking for this result:
A A
A B
B A
B B
B C
J A
Thanks
|