How can one collapse multiple rows of cell values in excel into a individual records while matching a unique id.

[ProsperChild]

I am facing a serious issue.i what to collapse multiple rows of data ,that is scattered in every rows of my workbook,with individual ids separated.

This is the challenge as attached.

My goal is to merge every scattered individual rows of record into a single rows. So that each one is merged with its own unique id.
Where duplicate Ids exist ,let the latter ids replace the former ids .

A null value in data can also replace digit number as well.

How do i achieve this?
Thanks

 

[ProsperChild]

WHERE STUDENTID ,NAME , CLASS ,CACHEM, EXAM CHEM ,TOTALCHEM, GRADECHEM,CABIO, EXAM BIO, TOTALBIO, GRADEBIO ARE THE COLUMN HEADERS FOR THE TABLE.