converting rows to comma delimited list

[peterswan]

Hello,

Is there a way to take a ton of rows of an id in the first column, an
output them into a comma delimited list so I can load them into a SQ
query and search on them?

Once I saw someone do this with the concatenate function but I can'
remember how it was done. If I could just add a comma on the end o
every instance of the id, I'd be solved.

Thanks,


Pete

 

[peterswan]

any help?

I've got 3000+ rows and just one column, an id field.

All I need to do is throw a comma in after every id.

That way I can copy the whole column and paste it into SQL Quer
Analyzer.

Thanks for any help,



Pete

 

[Gord Dibben]

Peter

Assuming column of data is A.

In B1 enter =A1 & ","

Double-click on the B1 fill handle to copy down 3000+ cells.

Copy Column B and Paste Special(in place)>Values>OK>Esc.

Delete Column A.

Gord Dibben Excel MVP