moving multiple fields in one table to one field in another table

[Guest]

I really hope someone can help me here, I'm going kind of nuts.
My problem is this:
I have a large (4000 line) excel spreadsheet, used for tracking activity at
a number of worksites, that I am trying to convert into a database.
The problem is that there are four fields that use the same data (they are
Managign organisation, owner, stakeholder 1 and stakeholder 2) they all draw
information from the same pool, and at any one worksite, a single
organisation may or may not have multiple roles.
If I was starting from scratch, I'm pretty comfortable with how I would do
this, but I am starting with 4000 lines of data, so my question is,
How can I extract the data from the four different fields, and link it to a
single field in a seperate table (i.e., all back to a single "organisation")

Any suggestions much appreciated.

Thanks

 

[Larry Daugherty]

From what you've given:

Four tables:

tblOrganization - has things about the organization. a lookup table

tblWorkSite- has things about the worksite and nothing else

tblRole - a lookup table, has a list of the roles: Manager, Owner,
Stakeholder

tblWorksiteRole - has an entry for each role in play at this worksite.
Populated with the Role name from tblRole and the role player from
tblorganization.

HTH