transpose a file and import into MS Access from Excel

[eHigh]

How can I transpose the file below?

Currently the file is in this format in Excel:

Employer
Contact
Misc (Sales, Employee #)
3-D IMAGING DEVELOPMENT
CONTACT: RODNEY WARNER, OWNER
NAICS: 2372
12301 N LAMAR BLVD
PHONE: (512)837-6644
SALES: $2.5 Million - $5 Million
AUSTIN, TX 78753-1314
FAX: (512)837-6040
# OF EMPLOYEES: 5 - 9
Travis County
DESCRIPTION: Real Estate Developers ,




Land Subdivision



7-ELEVEN FOOD STORE
PHONE: (512)835-5666
NAICS: 4451
8900 N LAMAR BLVD
DESCRIPTION: Convenience Stores ,
SALES: $1 Million - $2.5 Million
AUSTIN, TX 78753-5012
Convenience Stores
# OF EMPLOYEES: 5 - 9
Travis County









7-ELEVEN FOOD STORE
CONTACT: PAM KEPLER, MANAGER
NAICS: 4451
10111 N LAMAR BLVD
PHONE: (512)339-2038
SALES: $1 Million - $2.5 Million
AUSTIN, TX 78753-3601
DESCRIPTION: Convenience Stores ,
# OF EMPLOYEES: 10 - 19
Travis County
Convenience Stores

We would like to transpose the data above into rows/columns.
The file could be in Excel or MS Access.

Is there a simple Excel or Access function that does this?

Thanks in advance for any assistance.

 

[Elysium]

There is no 'simple' function for this. You'll have to read it into an array and then send it to a table. But, it's not simple.

Randy