Email addresses in one row and wants them as one column in excel

Simple! To transpose a row in Excel, follow these instructions:

1. Highlight the row (Click on the row number)
2. Copy contents
3. Click on a cell below your copied row
4. Right click to open the actions menu
5. Choose Paste special and click on the "transpose" button
6. You will have all your content in one column

(WARNING!)

This will overwrite existing data! Make sure to choose an open column to paste your contact data.