Consolidating rows

I have a sheet with various test data from students who have taken parts of the test at different times. Each result is its own row, but I need all results on the same row. Is there a formula or function to complete this to prevent having to go through the whole sheet and retyping.

For example

Currently, I get:

ID Last First RC SS Art EA CM
1 Student1 a 110 52
1 Student1 a 99 106
2 Student 2 b 54 42 29 31
3 Student 3 c 29 38
4 Student 4 d 29 44
4 Student 4 d 66 36
5 Student 5 e 41 64 25 37
6 Student 6 f 79 43
6 Student 6 f 68 55

I need to get:

ID Last First RC SS Art EA CM
1 Student1 a 99 106 110 52
2 Student 2 b 54 42 29 31
3 Student 3 c 29 38
4 Student 4 d 29 66 36 44
5 Student 5 e 41 64 25 37
6 Student 6 f 68 55 79 43

Sample sheet attached.

Try the following formula in M3, then fill down and fill right:

=IF(SUMIF($A$3:$A$11,$J3,D$3:D$11)=0,"",SUMIF($A$3:$A$11,$J3,D$3:D$11))

Originally Posted by cantosh

Try the following formula in M3, then fill down and fill right:

=IF(SUMIF($A$3:$A$11,$J3,D$3:D$11)=0,"",SUMIF($A$3:$A$11,$J3,D$3:D$11))

Thank you so much; saved me hours of hunting and typing. This seems to have solved the issue after I copied and pasted id, first name, last name, and remove duplicates.

Glad to help, good luck!