double-tripple-qad entries help

Hi all,
I have a table with two columns. One has ID's and the other e-mails. For one ID I can have many e-mails. The task is to create a table where I will have one column with unique entries of ID's and on the RHS of this column as many columns as the maximum number of e-mails of an ID...... I have tried too many things so far but no progress made. If someone could post any plan of approach I would be more than grateful.
Thank you all in advance

re: double-tripple-qad entries help

I think you need to give some careful consideration to exactly what you want.
Processing (using) data in the format you describe is not straightforward.
Also, the concept of a fixed number of columns that is fixed by a variable number of the contents in a dataset - doesn't make good sense.

re: double-tripple-qad entries help

I would suggest a second table with multiple entries for emails. The ID + an AutoNum field could be the key for the entries in the Email table.