merge(concantenate) cells by order

[turist]

In column A there are items like a,b,c,d,e,f,g,..... and goes on.
I want to merge(concantenate) items in column B like ab, ac,ad,ae,af,ag,bc,bd,be,bf,bg.......... and goes on.
I need by formula if possible, or macro .

Attached table sample data explained how to be listed.

Thanks in advance for any reply and help.
Regards,
turist

[alexander.small]

What about (for "a"):

=CONCATENATE($A$1," & ",A2)

Then apply that to the cells you need to display "a & (whatever letter)"

Then for "b & c" simply change it to:

=CONCATENATE($A$2," & ",A3)

Then apply this for the cells you want

[turist]

What about (for "a"):

=CONCATENATE($A$1," & ",A2)

Then apply that to the cells you need to display "a & (whatever letter)"

Then for "b & c" simply change it to:

=CONCATENATE($A$2," & ",A3)

Then apply this for the cells you want

Thanks for reply,
But it is easiest way of course manually.
If items go down thousands rows , how can be managed manually , it is a disaster.
So I need a formula only can be copied to down without any change.
Sorry, your solution will not working for a huge file.

[turist]

Waiting for quick reply.
Regards