Consolidating Records

[OldUser]

I have a table as such

ID Date
10 1/1/11
10 2/2/11
10 3/3/11
20 4/4/11
20 5/5/11
20 6/6/11
30
30
30

I'd like to consolidate to -

ID Date1 Date2 Date3
10 1/1/11 2/2/11 3/3/11
20 4/4/11 5/5/11 6/6/11
30 Null Null Null

I don't think concatenation handles date fields. I want a separate table with the additional fields, not as combined text.

Thanks.

[RayMilhon]

Not sure I understand are you trying to re-create the table in a different format or are you generating a report/form to display the data in a specific manner?

[OldUser]

I'm trying to create a whole new table with separate fields for the possible multiple date fields for each ID, including an ID with no entry in the original date field.