I am trying to use a Excel 2007 Piviot Table to translate this information

Name | Subject | Grade
Studentname 1 | Maths | D
Studentname 1 | Science | E
Studentname 1 | English | A
Studentname 2| Maths | A
Studentname 2 | Science | B
Studentname 2 | English | C

To a Privot Table like this

Name | Maths | Science | English
Studentname 1 | D | E | A
Studentname 2 | A | D | C

But it's showing this

Name | Maths | Science | English
Studentname 1 | 1 | 1 | 1
Studentname 2 | 1 | 1 | 1

Because in the Summery it's counting the grades.

How do I get excel just to show me the grade, and not count the grades?

thank you for any help.