Converting txt file to Excel

[Shawn]

I have a text file imported into Excel that is setup as
follows:

Account Number Account Registration Payee Information
001511xxxxxx John Doe US Bank
123 First Street 100 Powell Ave
Las Vegas, NV 00000 Las Vegas, NV

001512xxxxxx Jane Doe US Bank
124 First Street 100 Powell Ave
Las Vegas, NV 00000 Las Vegas, NV

And this report can have up to 400 accounts. Is there a
way to related the Account Registration and Payee
Information to the Account Number, which would include the
entire address? Right now it will only relate the first
row and not the 2-3 rows after it.

Any help would be appreciated.

 

[Doug Kanter]

What do you mean by "relate"???

 

[Guest]

Is there a way when trying to sort that the sorting will
keep the entire address together with the first line? So
that when I sort by Account Number it would include the
entire address for Account Registration and Payee
Information for that specific account number.

 

[Doug Kanter]

Not that I'm aware of, or more accurately, not without getting ridiculously
involved. This type of data is better dealt with using a database such as
Access or Paradox.