consolidate rows with the same ID# but different columns

Hi,

I need to consolidate a fairly large spreadsheet. ID#s (collumn A) can be repeated any number of times but each time they are repeated, there is a separate set of columns. I need each ID# to have its own row and I need the columns to remain but I need the values to be in the appropriate row. I have attached an example spreadsheet. Sheet 1 shows what I have and sheet 2 shows what I need. Thanks in advance for your help. It is much appreciated!

Edit: I guess it might be more "combining" rows than "consolidating"