Convert columns into unique rows

Hi there,
I have a very peculiar question .
I have data in columns that I need converted to rows with unique combinations.

For eg: I have a row with 5 columns:
A B C D E

I need this converted into rows with 2 columns as follows:

A B
A C
A D
A E
B C
B D
B E
C D
C E
D E

Has anyone done this before?? Please help!!

Copy row then paste special as "transpose".
unique combinations mean? Please give clear example. Thanks

thanks wenqq3. The transpose feature wont work. For eg
if I have a row with 3 columns:
NewYork LosAngeles Miami
I want it converted into rows where one combination exists for each of the 3 cities.

Ie -Final product:
Row1 - NewYork LosAngeles
Row 2 -NewYork Miami
Row 3-LosAngeles Miami

Hope I am making sense .

Hi, RoxyParker07

would you show us more examples , such like when data A...K ,A..C , the result will show ..
look like need vba if you have more rows

Yeah. I definitely have more rows. The number of columns will vary. For eg:
Row -A B C D E F

The output will be:
AB
AC
AD
AE
AF
BC
BD
BE
BF
CD
CE
CF
DE
DF
EF

Basically ,a unique combination of each of the data points. Does this help?

Yes yes yes! You are absolutely correct. Preferably each permutation appears just once
However, if it is easier to have both BA and AB combination appear then that should be ok too.

OMG! you are amazing. That did work. Thank you so so much. So very appreciated. You made my weekend