C
cwee
I have a 300,000 row database containing student ID#s and SAT scores.
Currently, each student has at least two rows (one for the verbal score and
one for the math score), organized like this:
ID# Section Score
555-55-5555 Verbal 650
555-55-5555 Math 680
I would like each student to only have one row, organized like this:
ID# VERB MATH
555-55-5555 650 680
Can anyone help me accomplish this?
Currently, each student has at least two rows (one for the verbal score and
one for the math score), organized like this:
ID# Section Score
555-55-5555 Verbal 650
555-55-5555 Math 680
I would like each student to only have one row, organized like this:
ID# VERB MATH
555-55-5555 650 680
Can anyone help me accomplish this?