How to Create Database from Single Column of Data

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

Relevant Pages

  • Advice on router security alert?
    ... Country: US ... OrgName: RIPE Network Coordination Centre ... City: Amsterdam ... PostalCode: 1001EB ...
    (comp.security.firewalls)
  • Re: How to identify distinct persons
    ... NULL, lastname VARCHARNULL, postalcode VARCHARNULL, address ... VARCHARNULL, city VARCHARNULL, country VARCHAR, idx INTEGER ... FROM Promotions AS P ...
    (microsoft.public.sqlserver.programming)
  • Re: Spammer/fraudster email harvesting from uk.finance
    ... City: Rochester ... StateProv: NY ... PostalCode: 14609 ... Country: US ...
    (uk.finance)
  • Re: How to identify distinct persons
    ... > (cust_number, firstname, lastname, postalcode, address, city, country) ... > FROM Promotions AS P ...
    (microsoft.public.sqlserver.programming)
  • Rare Entries Contest MSB63 begins
    ... Name a city where the modern Olympic Games have been held ... the number of entrants ... "Country" means an independent country. ... what you cite must already have existed before the contest was ...
    (rec.puzzles)
Loading