[Access 2007] fix bad design

[Zoroxeus]

Hi
i imported an excel file with the following strcture:
Field A: Accronym
Field B: Label1


Field C: Label2
Field D: Label3
(plus an primary key when i imported)

Sometimes Field C and D are empty.

What I am looking in doing is to get a good desgin is three tables
one with the accronyms, another one with the labels (without double in the unlikely event there were double labels) and the third table joining the two tables. Accronyms are unique.

I am just unsure how i can do other thsn typing it all ?
I tried to table analysis tool... but i can't do what i want to.
Do you have any idea ?

[recyan]

Just check out if below gives some guidelines :
Assuming table structure :

myTable
AcronymnID - PK
Acronymn - Assuming Unique in this table
Label1
Label2
Label3

The first query to run :
qrytblAcronymns

SELECT DISTINCT 
    myTable.AcronymnID, 
    myTable.Acronymn 
INTO 
    tblAcronymns
FROM 
    myTable;

The 2nd query to run :

qrytblLabels

SELECT
Label1 AS Label 
INTO 
    tblLabels
FROM 
    (
        SELECT Label1 FROM myTable WHERE Label1 Is Not Null
        UNION 
        SELECT Label2 FROM myTable WHERE Label2 Is Not Null 
        UNION 
        SELECT Label3 FROM myTable WHERE Label3 Is Not Null 
    );

The 3rd query :
qrytblAcronymnLabels

SELECT 
    AcronymnID AS Acronymn_ID, 
    Label1 AS Labels 
INTO 
    tblAcronymnsLabels
FROM 
    (
        SELECT AcronymnID, Label1 FROM myTable WHERE Label1 Is Not Null
        UNION 
        SELECT AcronymnID, Label2 FROM myTable WHERE Label2 Is Not Null 
        UNION 
        SELECT AcronymnID,Label3 FROM myTable WHERE Label3 Is Not Null 
    );

Thanks