Importing Text into Rows

  • Thread starter Thread starter brad
  • Start date Start date
B

brad

Morning All

This is a really simple question I'm sure will be solved
with a simple option or radio button, but I have spent too
much time trying to solve this, so here I am.
I have a delimited text file I am trying to import into
worksheet. The import is working fine, however, how do I
get the imported data to go along a row (A1, B1, C1, D1
etc) instead of importing into col's (A1, A2, A3, A4)?

TIA

Brad
 
Brad,

My suggestion would be to import the data in the normal
fashion (get it into columns). Select the data and hit Copy.
Go into an empty worksheet and choose Paste Special. In
the options check off Transpose.

Dan E
 
Back
Top