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.

Excel 2007 Pivot Table
Convert numbers to letters
with custom font.
No extra formulas or helpers.
http://c0444202.cdn.cloudfiles.racks.../01_21_10.xlsx