Sounds like all you want to do is to 'transpose' what you have successfully
imported so that the columns become rows and vice versa.

If so, fairly easy.

1) Import your text file as before, so that everything that *should* be
row(s) continues to be in its own column(s); i.e. use the 'Delimited' and
'Comma' options during the import step.

2) Select ALL the rows and columns that have been inserted into the
resulting EXCEL sheet.

3) Select (click) the cell in the spreadsheet where you would like the
correctly orientated table to start from.

4) Select 'Paste Special' from the 'Edit' menu.

5) Click the 'Transpose' option.

6) Select 'OK'.

A correctly orientated copy of your original import should now appear.

--
"May the Word be with you."



"Dave Plyer" wrote:

I use the Import Text Wizard to paste comma delimited text into an Excel
spread sheet. I end up with a single row of multiple columns. One column for
each piece of delimited text. What I really want is delimited text in a
single column of mutliple rows. One row for each piece of delimited text. How
can this be done?