Import or open text file and directly transpose the data

I don't think that is possible to do the transosing while importing.

A better bet would be to write a parsing macro that runs through the text and adds the data in columns.

Try searching on 'parsing text file'

The macro should not be too difficult:
Open the text file, read through the text parsing on your delimiter, and then writing the parsed text donw in a column.
When the CrLf character is encountered the next column is used.
at the end close the text file.