• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Importing Column Text To Rows Only (Not Columns)

I

indi visual

Member
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
 
Can you import it into a column and then Copy, Paste Special, Transpose
 
Yes! I knew I missing something simple thank you. It was late and I just couldn't remember transpose thanks again Hui : )
 
You must log in or register to reply here.
Back
Top