Make all vertical information into one cell.

[JasonNeedsHelp]

Hello,

In Column A, i have a list of numbers... like so:

304371
312175
315315
315513
319152
328454
334670

I would like in cell C1 to transpose the vertical information into the one cell while adding a comma between each value... list so:

304371,312175,315315,315513,319152,328454,334670

Note: I would like no comma in the end.

Thanks in advance for the help!

[Pete_UK]

Put this formula in B1:

=A1

and this formula in B2:

=IF(A2="","",A1 & "," & B2)

Copy this down as far as you need to - the final result is in the bottom cell.

Hope this helps.

Pete