reorganizing a table

I have a table with one column being an identification number and the next two have a set of data. there are several occurances of repeating identification numbers. Can you restructure table to list the id number and the data in a single row.