paste column to row

[Help with excel]

I have a list like this in excel:
0000030017
0000030020
0000030057
0000030084
0000030211
What I want to do is paste it horizonal and add in comma, so it would look
like this in excel:
30017, 30020, 30057, ....
Please tell me if there is a formula to have Excel do this? Thank you.

 

[JulieD]

Hi

select your data
choose copy, click in the destination (just one cell) and choose edit /
paste special and click the transpose box - click OK

they probably will paste with the leading 0000
so now, select a blank, unused cell and choose copy
select the row that you pasted earlier and choose
edit / paste special - ADD click OK

and you should have what you want.

Note, paste special - transpose does not work with a "cut" range
additionally you have only 256 columns so your data range needs to be equal
to or less that that

Hope this helps
Cheers
JulieD