Spreadsheet: 40361d1238676449-transposing-grades-sample
Sheet: Sheet1

Here's what it looks like now
 | 2008-2009 |  |  |  | 2008-08-12 00:00:00 | 2008-08-13 00:00:00 | 2008-08-14 00:00:00 | 2008-08-15 00:00:00 | 2008-08-15 00:00:00 | 2008-08-18 00:00:00 | 2008-08-19 00:00:00 | 2008-08-20 00:00:00 | 2008-08-21 00:00:00 | 2008-08-22 00:00:00 | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | 2008-08-27 00:00:00 | 2008-08-28 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00 | 2008-09-02 00:00:00 | 2008-09-03 00:00:00 | 2008-09-03 00:00:00 | 2008-09-04 00:00:00 | 2008-09-05 00:00:00 | 2008-09-08 00:00:00 | 2008-09-10 00:00:00 | 2008-09-12 00:00:00 | 2008-09-15 00:00:00 | 2008-09-16 00:00:00 | 2008-09-17 00:00:00 | 2008-09-18 00:00:00 | 2008-09-19 00:00:00 | 2008-09-22 00:00:00 | 2008-09-23 00:00:00 | 2008-09-24 00:00:00 | 2008-09-25 00:00:00 | 2008-09-26 00:00:00 | 2008-10-01 00:00:00 | 2008-10-02 00:00:00 | 2008-10-03 00:00:00 | 2008-10-06 00:00:00 | 2008-10-07 00:00:00 | 2008-10-08 00:00:00
 | Grades | AVG (with lowest grade dropped) | FINAL AVG | Grade | Assignment 1 | Assignment 2 | Assignment 3 | Assignment 4 | Assignment 5 | Assignment 6 | Assignment 7 | Assignment 8 | Assignment 9 | Assignment 10 | Assignment 11 | Assignment 12 | Assignment 13 | Assignment 14 | Assignment 15 | Assignment 16 | Assignment 17 | Assignment 18 | Assignment 19 | Assignment 20 | Assignment 21 | Assignment 22 | Assignment 23 | Assignment 24 | Assignment 25 | Assignment 26 | Assignment 27 | Assignment 28 | Assignment 29 | Assignment 30 | Assignment 31 | Assignment 32 | Assignment 33 | Assignment 34 | Assignment 35 | Assignment 36 | Assignment 37 | Assignment 38 | Assignment 39 | Assignment 40 | 9 Weeks Test
1 | Student A | 86.33333333333333 | 87.63333333333333 | B | 100 | 100 | 100 | 100 | - | 100 | 100 | 100 | 100 | 100 | 70 | 100 | 100 | 38 | 90 | 39 | 83 | 80 | 100 | 70 | 80 | 70 | 100 | 80 | 95 | 70 | 90 | 70 | 70 | 95 | 70 | 70 | 89 | 92 | 90 | 87 | 75 | 100 | 80 | 67 | 95
Here's what I want it to look like when I click on "Student A"
 |  | 1
2008-2009 | Grades | Student A
 | AVG (with lowest grade dropped) | 86.33333333333333
 | FINAL AVG | 87.63333333333333
 | Grade | B
2008-08-12 00:00:00 | Assignment 1 | 100
2008-08-13 00:00:00 | Assignment 2 | 100
2008-08-14 00:00:00 | Assignment 3 | 100
2008-08-15 00:00:00 | Assignment 4 | 100
2008-08-15 00:00:00 | Assignment 5 | -
2008-08-18 00:00:00 | Assignment 6 | 100
2008-08-19 00:00:00 | Assignment 7 | 100
2008-08-20 00:00:00 | Assignment 8 | 100
2008-08-21 00:00:00 | Assignment 9 | 100
2008-08-22 00:00:00 | Assignment 10 | 100
2008-08-25 00:00:00 | Assignment 11 | 70
2008-08-26 00:00:00 | Assignment 12 | 100
2008-08-27 00:00:00 | Assignment 13 | 100
2008-08-27 00:00:00 | Assignment 14 | 38
2008-08-28 00:00:00 | Assignment 15 | 90
2008-08-28 00:00:00 | Assignment 16 | 39
2008-08-29 00:00:00 | Assignment 17 | 83
2008-09-02 00:00:00 | Assignment 18 | 80
2008-09-03 00:00:00 | Assignment 19 | 100
2008-09-03 00:00:00 | Assignment 20 | 70
2008-09-04 00:00:00 | Assignment 21 | 80
2008-09-05 00:00:00 | Assignment 22 | 70
2008-09-08 00:00:00 | Assignment 23 | 100
2008-09-10 00:00:00 | Assignment 24 | 80
2008-09-12 00:00:00 | Assignment 25 | 95
2008-09-15 00:00:00 | Assignment 26 | 70
2008-09-16 00:00:00 | Assignment 27 | 90
2008-09-17 00:00:00 | Assignment 28 | 70
2008-09-18 00:00:00 | Assignment 29 | 70
2008-09-19 00:00:00 | Assignment 30 | 95
2008-09-22 00:00:00 | Assignment 31 | 70
2008-09-23 00:00:00 | Assignment 32 | 70
2008-09-24 00:00:00 | Assignment 33 | 89
2008-09-25 00:00:00 | Assignment 34 | 92
2008-09-26 00:00:00 | Assignment 35 | 90
2008-10-01 00:00:00 | Assignment 36 | 87
2008-10-02 00:00:00 | Assignment 37 | 75
2008-10-03 00:00:00 | Assignment 38 | 100
2008-10-06 00:00:00 | Assignment 39 | 80
2008-10-07 00:00:00 | Assignment 40 | 67
2008-10-08 00:00:00 | 9 Weeks Test | 95