Importing Text into Rows

[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

 

[Dan E]

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