View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jack jack is offline
external usenet poster
 
Posts: 186
Default Converting multiple rows into columns

I am working on a list of contacts that is listed by rows and columns in the
following manner:

Column A Coilumn B

ABC Inc
Address: Primary Contact:
1 Main Street John Doe
Mainvile CT 06405 Business Type:
Contractor/SubContractor
Phone: 203-555-0000
Fax: 203-555-0001
Email:

I need to convert the data into columns to import into my ACT database. CAn
anyone help??? Thanks in advance...

Jack