I have a text file that has information in rows. For Example

FieldA XXXX
FieldB XXXX
FieldC XXXX
FieldD XXXX

FieldA XXXX
FieldB XXXX
FieldC XXXX
FieldD XXXX

FieldA XXXX
FieldB XXXX
FieldC XXXX
FieldD XXXX

So I import the text file and I get exactly that. Every line on a ne
row. What I woul like to do is get something more like this:

FieldA FieldB FieldC FieldD
XXXX XXXX XXXX XXXX
XXXX XXXX XXXX XXXX
XXXX XXXX XXXX XXXX

There has to be a way to do this, but I am racking my brain!!!! Help
Any suggestions?

Thank you,
Mar

--
Message posted from http://www.ExcelForum.com