Column To Row Comma Delimited

You want to move the contents in column A to Row 1 : See examples

http://www.ozgrid.com/forum/showthread.php?t=107947&page=1

Open a new worksheet it will label them sheet one, two and three
On sheet1
Copy your list to column A starting from row 1, as I have done.
Highlight the code from the website and take a copy
Go to your workbook sheet1
Press ALT and F11
This will open Microsoft Visual Basic Editor
On the Insert tab press Module
Paste in the code then press save
Now on the Run tab scroll down to Run Sub/UserForm