Database Design

[accessprogram]

Hello,

I am trying to design a new table that has 5 columns and first column is based on ID and second column is based on messages. the old table has 10 columns where first column is again ID and all other columns are showing messages related to this ID vertically. now I want to bring down all of the 10 columns messages into the new table 2 column but what happens is that first column has Id 1,2,3,4 and 2 column will now show messages related to Id 1 near ID 2,3,4,5 and 2 column will have more fields compare to ID, I want to match ID and multiple message related to the same Id like
ID Errors
1 error1
1 erro2
1 erro3
1 erro5


2 erro3
2 erro3
2 erro4
2 erro5

Please help me fixing this problem. how can the query be designed to sort the ID and grouping the messages related to matching ID?

[pbaldy]

You can use a union query:

SELECT ID, Error1
FROM TableName
WHERE Error1 Is Not Null
UNION ALL
SELECT ID, Error2
FROM TableName
WHERE Error2 Is Not Null
UNION ALL
...