Transpose columns to rows with help of formula

[Gaurang Mhatre]

Hi Friends,
I have account numbers tag to account holders which are in different columns in different cells,
I need account numbers in rows against each account holder in single cell and not in different cells.

Is there any formula for doing this. Attached excel for reference.


Thanks for help in advance

Regards,
Gaurang Mhatre

 

[Hui]

Assuming you have a small list
I would simply use a manual technique like
=A2&","&A3&","&A4&","&A5

Add and remove cells as required

 

[Chihiro]

If you have large set, you can do something like.

in B2: =A2
in B3: =B2&","&A2
Copy down to B5.

Copy B2 to B8 and Copy B3 to B9. So on so forth.

You will have concatenated cell at last row of each set.