C
cwee
I have a 300,000 row database of student names and SAT scores. There are
three columns, student ID#, Section_Type (verbal or math), and then the score
itself. So, each student has 2 rows, like this:
ID# Section Score
555-55-5555 VERB 650
555-55-5555 MATH 680
I would like every student to be on just one row, with verbal score in one
column, and math score in the next, to look like this:
ID# Verbal Math
555-55-5555 650 680
Can anyone help me do this?
three columns, student ID#, Section_Type (verbal or math), and then the score
itself. So, each student has 2 rows, like this:
ID# Section Score
555-55-5555 VERB 650
555-55-5555 MATH 680
I would like every student to be on just one row, with verbal score in one
column, and math score in the next, to look like this:
ID# Verbal Math
555-55-5555 650 680
Can anyone help me do this?