Spreadsheet: 872090d1718443372-need-help-in-tranposing-table-exam-results-sample
Sheet: Class A

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]) |  | [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
StudentA1 | 73 | A2 |  |  |  |  | 66 | B3 |  |  |  |  |  |  |  |  |  |  | 53 | C6 |  |  |  |  | 55 | C5 |  |  |  |  | 81 | A1 | 69 | B3 | 70 | A2 |  |  |  |  |  |  | 84 | P |  |  | VR | VR | 73 | P
StudentA2 |  |  | 43 | 6 |  |  |  |  |  |  |  |  |  |  | 43 | 6 |  |  |  |  |  |  | 30 | E |  |  |  |  | 56 | D |  |  |  |  |  |  |  |  |  |  |  |  | 42 | U | 70 | B | VR | VR | 77 | P
StudentA3 |  |  | 53 | 5 |  |  | 52 | C6 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 5 |  |  |  |  | 50 | 5 |  |  |  |  |  |  |  |  | 48 | 6 | 89 | 1 | 60 | 4 | 40 | U |  |  | VR | VR | 71 | P
StudentA4 | 53 | C6 | 98 |  |  |  | 48 | D7 |  |  |  |  |  |  |  |  |  |  | 40 | E8 |  |  |  |  | 33 | 9 |  |  |  |  | 62 | B4 | 79 | A1 | 55 | C5 |  |  |  |  |  |  | 64 | P |  |  | VR | VR | 57 | P
StudentA5 |  |  | 50 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 83 | A1 |  |  | 40 | 6 |  |  |  |  | 60 | 4 |  |  |  |  |  |  |  |  | 43 | 6 | 57 | 5 | 60 | 4 | 60 | P |  |  | VR | VR | 66 | P
StudentA6 | 99 | C6 |  |  |  |  | 51 | C6 |  |  |  |  |  |  |  |  |  |  | 73 | A2 |  |  |  |  | MC | MC |  |  |  |  | 52 | C6 | 70 | A2 | MC | MC |  |  |  |  |  |  | MC | MC |  |  | VR | VR | 66 | P
StudentA7 |  |  | 43 | 6 |  |  | 57 | C5 |  |  |  |  |  |  |  |  |  |  | 60 | B4 |  |  |  |  |  |  | 18 | 6 |  |  |  |  |  |  |  |  | 53 | 5 | 65 | 3 | 60 | 4 | 46 | U |  |  | VR | VR | 69 | P
StudentA8 |  |  | 57 | 5 |  |  |  |  | 56 | 5 |  |  |  |  |  |  |  |  | 43 | E8 |  |  |  |  |  |  | 50 | 5 |  |  |  |  | 64 | B4 |  |  | 81 | 1 |  |  | 50 | 5 | 72 | P |  |  | VR | VR | 66 | P
StudentA9 | 57 | C5 |  |  |  |  | 62 | B4 |  |  |  |  |  |  |  |  |  |  | 77 | A1 |  |  |  |  | 53 | C6 |  |  |  |  | 81 | A1 | 82 | A1 | 55 | C5 |  |  |  |  |  |  | 68 | P |  |  | VR | VR | 70 | P
StudentA10 | 67 | B3 |  |  |  |  | 42 | E8 |  |  |  |  |  |  |  |  |  |  | 97 | A1 |  |  |  |  | 55 | C5 |  |  |  |  | 71 | A2 | 77 | A1 | 65 | B3 |  |  |  |  |  |  | 74 | P |  |  | VR | VR | 63 | P
StudentA11 |  |  | 43 | 6 |  |  |  |  |  |  |  |  |  |  | 27 | 6 |  |  |  |  | AB | AB |  |  |  |  |  |  | AB | AB |  |  |  |  |  |  |  |  |  |  |  |  | 38 | U | 37 | E | VR | VR | 40 | U
StudentA12 | 60 | B4 |  |  |  |  | 81 | A1 |  |  |  |  |  |  |  |  |  |  | 80 | A1 |  |  |  |  | 60 | B4 |  |  |  |  | 86 | A1 | 80 | A1 | 60 | B4 |  |  |  |  |  |  | 78 | P |  |  | VR | VR | 80 | P
StudentA13 |  |  | 67 | 3 |  |  |  |  |  |  |  |  | 40 | E8 |  |  |  |  |  |  | 57 | 5 |  |  |  |  | 30 | 6 |  |  |  |  |  |  |  |  | 71 | 2 | 83 | 1 | 65 | 3 | 86 | P |  |  | VR | VR | 79 | P
StudentA14 | 57 | C5 |  |  |  |  | 72 | A2 |  |  |  |  |  |  |  |  |  |  | 87 | A1 |  |  |  |  | 63 | B4 |  |  |  |  | 71 | A2 | 64 | B4 | 55 | C5 |  |  |  |  |  |  | 28 | U |  |  | VR | VR | 71 | P
StudentA15 |  |  | 57 | 5 |  |  |  |  |  |  |  |  | 50 | C6 |  |  |  |  |  |  | 13 | 6 |  |  |  |  | 25 | 6 |  |  |  |  |  |  |  |  | 52 | 5 | 80 | 1 | 60 | 4 | 82 | P |  |  | VR | VR | 73 | P
StudentA16 |  |  | 53 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 92 | A1 |  |  | 50 | 5 |  |  |  |  | 40 | 6 |  |  |  |  |  |  |  |  | 52 | 5 | 94 | 1 | 60 | 4 | 78 | P |  |  | VR | VR | 81 | P
StudentA17 |  |  | 53 | 5 |  |  | 28 | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 6 |  |  |  |  | 33 | 6 |  |  |  |  |  |  |  |  | 38 | 6 | 72 | 2 | 45 | 6 | 54 | P |  |  | VR | VR | 57 | P
StudentA18 | 60 | B4 |  |  |  |  | 45 | D7 |  |  |  |  |  |  |  |  |  |  | 73 | A2 |  |  |  |  | 65 | B3 |  |  |  |  | 81 | A1 | 65 | B3 | 65 | B3 |  |  |  |  |  |  | 70 | P |  |  | VR | VR | 73 | P
StudentA19 | 67 | B3 |  |  |  |  | 69 | B3 |  |  |  |  |  |  |  |  |  |  | 40 | E8 |  |  |  |  | 35 | 9 |  |  |  |  | 86 | A1 | 76 | A1 | 60 | B4 |  |  |  |  |  |  | 76 | P |  |  | VR | VR | 66 | P
StudentA20 | 70 | A2 |  |  |  |  | 38 | 9 |  |  |  |  |  |  |  |  |  |  | 70 | A2 |  |  |  |  | 68 | B3 |  |  |  |  | 81 | A1 | 88 | A1 | 75 | A1 |  |  |  |  |  |  | 86 | P |  |  | VR | VR | 76 | P