Importing Column Text To Rows Only (Not Columns)

[indi visual]

I am trying to import this vertically stacked column of text:


A

B

C

D

E


...Into Excel to each horizontal row like this:


A B C D E

 

[Hui]

Can you import it into a column and then Copy, Paste Special, Transpose

 

[indi visual]

Yes! I knew I missing something simple thank you. It was late and I just couldn't remember transpose thanks again Hui : )