Same ID in a row

[digit]

Hi i have table like this :

ID	SIZE 1	SIZE 2	SIZE 3	SIZE 4
1	12	14	16	18
2	12	16
3	14
4
5	10	12

I need to be like this :

ID	SIZE
1	12
1	14
1	16
1	18
2	12
2	16
3	14
4
5	10
5	12

I know that this is very easy but im new. Can you help me.

[JoeM]

Here is one way:
Create the table structure of your new table (with two fields).
Then, create 4 append queries, to write the table from your original table to your new table.
The first one would write ID and Size 1 field to the new table.
The second one would write ID and Size 2 field to the new table
etc, etc

[June7]

Use a UNION query to rearrange data to normalized structure.

SELECT ID, Size1 AS Size FROM tablename
UNION SELECT ID, Size2 FROM tablename
UNION SELECT ID, Size3 FROM tablename
UNION SELECT ID, Size4 FROM tablename;

Then use that query in other queries, even a MAKE TABLE or INSERT.