Ok I have seven unique text items in two columns and need a formula that will
give me all the possible combinations in a list. The columns are as follows.

Column 1
KEY
KNOB
2KEY
2KNOB
<blank

Column 2
KEY
KNOB
KK
2KK
2KEY
2KNOB
<blank

What I am looking for is a way to list in two columns the unique
combinations of Column1 & Column2 so I can insert a third column next to give
a value to be used in a VLOOKUP formula.

Thank You in advance