How to format in column not a row

[Steve Swift]

Hi all,

I have a text file containing email addresses which I need to convert to a csv. When I import it into excel it places all the email address correctly into separate cells but all in row 1, 1a, 1b, 1c etc

How do I make excel put those into 1a,2a,3a,4a, etc

Thanks in advance

Steve

 

[lenze]

Have a look at Transpose Function or Copy>PasteSpecial>Transpose

lenze

 

[Steve Swift]

Perfect, just what I needed thanks



Steve