What is it that you actually want to do? (The best approach depends on what your desired end result
is...) Do you want an overall average? Or to produce a report with the class and quarter values
included as headers?

HTH,
Bernie
MS Excel MVP


"Cytorak" wrote in message
...
I have an extract from a student information system in Excel that
looks like this.

Student Class Grade Quarter
John Chemistry 70 1
John Chemistry 80 2
John Math 95 1
John Math 100 2
Alice Chemistry 67 1
Alice Chemistry 47 2
Alice Math 88 1
Alice Math 85 2

What I would like is this:

John 70 80 95 100
Alice 67 47 88 85

However, since there are hundreds of students, this would be an
extreme pain to do by hand. Is there any built-in formula or function
in Excel that can do this?