How to turn a vertical list in excel into a horizontal csv?

bledd · 12 Apr 2011 at 11:07

I've got a file like this

name1
name2
name3
name4

I want to turn it into

name1, name2, name3, name4

How do I do this in Excel? (or any other program)

Pho · 12 Apr 2011 at 11:11

http://office.microsoft.com/en-us/excel-help/transpose-function-HP010342964.aspx

Or copy your data, right click and go to paste special > transpose.

bledd · 12 Apr 2011 at 11:22

Ah, I was copying from notepad to excel and not seeing the extra Paste Special options

Had to copy from within Excel to get that option

Thanks

Sin_Chase · 12 Apr 2011 at 22:24

Assuming it's a single list you want in CSV format and not a table of actual data you could have, without any office software, done a find and replace on the line break.

For example in EditPlus you could paste the data in, done a search on \n and replaced with ", "

bledd · 13 Apr 2011 at 11:47

Thanks for the tip, I didn't know you could do that.

I know you can copy a 'tab' in notepad (and notepad2) and replace it with a comma