Spreadsheet: 872577d1718955117-need-help-in-tranposing-table-exam-results-sample
Sheet: Class C

Student | English Language - EXP |  | English Language - N(A) |  | English Language - N(T) |  | Chinese Language - EXP |  | Chinese Language - N(A) |  | Basic Chinese Language - N(T) |  | [NAME] |  | [NAME]) |  | Higher [NAME] |  | [NAME]) |  | Mathematics - EXP |  | Mathematics - N(A) |  | Mathematics - N(T) |  | Science - EXP |  | Science - N(A) |  | Science - N(T) |  | Geography - EXP |  | History - EXP |  | Literature in English - EXP |  | Geography - N(A) |  | History - N(A) |  | Literature in English - N(A) |  | Art - CMN |  | Computer Applications - N(T) |  | Design & Technology - CMN |  | Food & Consumer Education - CMN
 | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade
StudentC1 | 60 | B4 |  |  |  |  | 90 | A1 |  |  |  |  |  |  |  |  |  |  |  |  | 90 | A1 |  |  |  |  | 75 | A1 |  |  |  |  | 71 | A2 | 94 | A1 |  |  |  |  |  |  |  |  | 90 | P |  |  | VR | VR | 81 | P
StudentC2 |  |  | 47 | 6 |  |  | 54 | C6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 |  |  |  |  | 35 | 6 |  |  |  |  |  |  |  |  | 62 | 4 | 70 | 2 | 30 | 6 | 60 | P |  |  | VR | VR | 63 | P
StudentC3 |  |  | 67 | 3 |  |  |  |  |  |  |  |  | 73 | A2 |  |  |  |  |  |  |  |  | 30 | 6 |  |  |  |  | 43 | 6 |  |  |  |  |  |  |  |  | 67 | 3 | 75 | 1 | 45 | 6 | 80 | P |  |  | VR | VR | 74 | P
StudentC4 |  |  | 63 | 4 |  |  |  |  |  |  |  |  | 50 | C6 |  |  |  |  |  |  |  |  | 13 | 6 |  |  |  |  | 40 | 6 |  |  |  |  |  |  |  |  | 48 | 6 | 62 | 4 | 40 | 6 | 40 | U |  |  | VR | VR | 61 | P
StudentC5 | 53 | C6 |  |  |  |  | 57 | C5 |  |  |  |  |  |  |  |  |  |  |  |  | 93 | A1 |  |  |  |  | 43 | E8 |  |  |  |  | 71 | A2 | 80 | A1 |  |  |  |  |  |  |  |  | 74 | P |  |  | VR | VR | 61 | P
StudentC6 |  |  | 63 | 4 |  |  | 66 | B3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 2 |  |  | 40 | E8 |  |  |  |  |  |  | 85 | A1 |  |  | 57 | 5 |  |  | 70 | 2 | 70 | P |  |  | VR | VR | 71 | P
StudentC7 | 57 | C5 |  |  |  |  | 70 | A2 |  |  |  |  |  |  |  |  |  |  |  |  | 73 | A2 |  |  |  |  | 50 | C6 |  |  |  |  | 71 | A2 | 81 | A1 |  |  |  |  |  |  |  |  | 80 | P |  |  | VR | VR | 70 | P
StudentC8 |  |  | 47 | 6 |  |  |  |  |  |  |  |  | 40 | E8 |  |  |  |  |  |  |  |  | 7 | 6 |  |  |  |  | 35 | 6 |  |  |  |  |  |  |  |  | 67 | 3 | 60 | 4 | 55 | 5 | 70 | P |  |  | VR | VR | 61 | P
StudentC9 | 63 | B4 |  |  |  |  | 61 | B4 |  |  |  |  |  |  |  |  |  |  |  |  | 73 | A2 |  |  |  |  | 38 | 9 |  |  |  |  | 67 | B3 | 77 | A1 |  |  |  |  |  |  |  |  | 90 | P |  |  | VR | VR | 76 | P
StudentC10 | 53 | C6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | A1 |  |  | 83 | A1 |  |  |  |  | 70 | A2 |  |  |  |  | 81 | A1 | 90 | A1 |  |  |  |  |  |  |  |  | 100 | P |  |  | VR | VR | 69 | P
StudentC11 |  |  | 43 | 6 |  |  |  |  |  |  |  |  | 57 | C5 |  |  |  |  |  |  |  |  | 13 | 6 |  |  |  |  | 25 | 6 |  |  |  |  |  |  |  |  | 67 | 3 | 52 | 5 | 30 | 6 | 60 | P |  |  | VR | VR | 67 | P
StudentC12 |  |  | 40 | 6 |  |  |  |  |  |  |  |  |  |  | AB | AB |  |  |  |  |  |  |  |  | 43 | E |  |  |  |  | 68 | C |  |  |  |  |  |  |  |  |  |  |  |  | 12 | U | 87 | A | VR | VR | 50 | P
StudentC13 | 57 | C5 |  |  |  |  |  |  |  |  |  |  | 53 | C6 |  |  |  |  |  |  | 90 | A1 |  |  |  |  | 58 | C5 |  |  |  |  | 76 | A1 | 77 | A1 |  |  |  |  |  |  |  |  | 78 | P |  |  | VR | VR | 76 | P
StudentC14 |  |  | 57 | 5 |  |  |  |  | MC | MC |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 6 |  |  |  |  | 45 | 6 |  |  |  |  |  |  |  |  | 67 | 3 | 65 | 3 | 50 | 5 | 78 | P |  |  | VR | VR | 50 | P
[NAME] | 57 | C5 |  |  |  |  |  |  |  |  |  |  | 70 | A2 |  |  |  |  |  |  | 60 | B4 |  |  |  |  | 50 | C6 |  |  |  |  | 76 | A1 | 84 | A1 |  |  |  |  |  |  |  |  | 100 | P |  |  | VR | VR | 69 | P
StudentC16 | 43 | E8 |  |  |  |  | 51 | C6 |  |  |  |  |  |  |  |  |  |  |  |  | 60 | B4 |  |  |  |  | 23 | 9 |  |  |  |  | 71 | A2 | 80 | A1 |  |  |  |  |  |  |  |  | 72 | P |  |  | VR | VR | 71 | P
StudentC17 | 60 | B4 |  |  |  |  | 46 | D7 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 9 |  |  |  |  | 25 | 9 |  |  |  |  | 67 | B3 | 79 | A1 |  |  |  |  |  |  |  |  | 68 | P |  |  | VR | VR | 71 | P
StudentC18 |  |  | 57 | 5 |  |  |  |  | 32 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | D |  |  |  |  | 60 | C |  |  |  |  |  |  |  |  |  |  |  |  | 68 | P | 99 | A | VR | VR | 61 | P
StudentC19 | 63 | B4 |  |  |  |  | 71 | A2 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | C6 |  |  |  |  | 40 | E8 |  |  |  |  | 67 | B3 | 87 | A1 |  |  |  |  |  |  |  |  | 74 | P |  |  | VR | VR | 74 | P
StudentC20 |  |  | 50 | 5 |  |  | 32 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 5 |  |  |  |  | 28 | 6 |  |  |  |  |  |  |  |  | 52 | 5 | 69 | 3 | 55 | 5 | 70 | P |  |  | VR | VR | 64 | P