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
Code:
SELECT DISTINCT
myTable.AcronymnID,
myTable.Acronymn
INTO
tblAcronymns
FROM
myTable;
The 2nd query to run :
qrytblLabels
Code:
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
Code:
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