Hi,

I have about one thousand lines of data in a single column. The headings
are repetitive and the data is separated from the heading by a colon (in the
same column). An example is provided below. I would like to create a
database, where the repetitive headings are stripped out and placed
horizontally, and the data filled accordingly, is it possible to automate
this?

OrgName: Corning Incorporated
OrgID: CORNIN
Address: Corning Incorporated
Address: SP-WW-01-1
City: Corning
StateProv: NY
PostalCode: 14831
Country: US

OrgName: University of Michigan Medical Center (MCIT)
OrgID: UMMCM
Address: 4251 Plymouth Rd., Suite 3300
City: Ann Arbor
StateProv: MI
PostalCode: 48105
Country: US

OrgName: Carleton University
OrgID: CARLET-1
Address: Computing and Communications Services
Address: 401 Administration Building
City: Ottawa
StateProv: ON
PostalCode: K1S-5B6
Country: CA

OrgName: Harvard University
OrgID: HARVAR
Address: UIS Network Operations Center
Address: Jay Tumas - Network Operations Manager
Address: 60 Oxford Street
Address: Suite 132
City: Cambridge
StateProv: MA
PostalCode: 02138
Country: US

..
..
..

I would like it to look like the following, so I can use as a database:

Org Name Org ID Address Address City State PostalCode
Company 1 Data
Company 2 Data

Hopefully I do not need to accomplish this by hand every time I get a
Report. Basically I recieve the report in MS Word. I then need to
copy/paste into Excel and from here somehow parse.

Any help or insight provided would be greatly appreciated.