S
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.
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.