Importing Text

Works fine for me.

I copied the sample data into a text file and then used Data | From text to import the .txt file.

See the attached picture of the settings I used.

The only thing I can think of is that you have some new line characters in there somewhere but I'm not sure that would give the effect you're seeing. I'd have thought that would be noticeable if you viewed the file in, say, Notepad.

Perhaps you could upload part of the text file, edited if necessary, and a copy of the workbook you are trying to import it to.

Regards