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

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]) |  | Basic Malay 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 | % | Grade | % | Grade | % | Grade
StudentB1 |  |  | 67 | 3 |  |  |  |  | 38 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | C6 |  |  |  |  |  |  | 40 | 6 |  |  |  |  | 58 | C5 |  |  | 57 | 5 |  |  | 55 | 5 | 68 | P |  |  | VR | VR | 71 | P
StudentB2 |  |  | 53 | 5 |  |  | 55 | C5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 6 |  |  |  |  | 53 | 5 |  |  |  |  |  |  |  |  | 86 | 1 | 91 | 1 | 85 | 1 | 82 | P |  |  | VR | VR | 64 | P
StudentB3 | 57 | C5 |  |  |  |  | 10 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 | A1 |  |  |  |  | 55 | C5 |  |  |  |  | 57 | C5 | 55 | C5 | 60 | B4 |  |  |  |  |  |  | 64 | P |  |  | VR | VR | 61 | P
StudentB4 |  |  | 53 | 5 |  |  |  |  |  |  | 60 | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 | C |  |  |  |  | 64 | C |  |  |  |  |  |  |  |  |  |  |  |  | 78 | P | 90 | A | VR | VR | 73 | P
StudentB5 |  |  | 50 | 5 |  |  |  |  |  |  |  |  |  |  | 50 | 5 |  |  |  |  |  |  |  |  |  |  | 23 | 6 |  |  |  |  | 53 | 5 |  |  |  |  |  |  |  |  | 67 | 3 | 59 | 5 | 75 | 1 | 78 | P |  |  | VR | VR | 74 | P
StudentB6 | 57 | C5 |  |  |  |  | 58 | C5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 | A1 |  |  |  |  | 38 | 9 |  |  |  |  | 62 | B4 | 82 | A1 | 65 | B3 |  |  |  |  |  |  | 70 | P |  |  | VR | VR | 66 | P
StudentB7 |  |  | 53 | 5 |  |  | 46 | D7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | 2 |  |  |  |  | 50 | 5 |  |  |  |  |  |  |  |  | 53 | 5 | 78 | 1 | 50 | 5 | 64 | P |  |  | VR | VR | 69 | P
StudentB8 | 53 | C6 |  |  |  |  | 36 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | E8 |  |  |  |  | 50 | C6 |  |  |  |  | 86 | A1 | 71 | A2 | 70 | A2 |  |  |  |  |  |  | 82 | P |  |  | VR | VR | 66 | P
StudentB9 |  |  | 57 | 5 |  |  | 55 | C5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 | A1 |  |  |  |  | 60 | B4 |  |  |  |  |  |  |  |  |  |  | 53 | 5 | 78 | 1 | 70 | 2 | 46 | U |  |  | VR | VR | 70 | P
StudentB10 | 53 | C6 |  |  |  |  | 41 | E8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77 | A1 |  |  |  |  | 58 | C5 |  |  |  |  | 57 | C5 | 70 | A2 | 55 | C5 |  |  |  |  |  |  | 68 | P |  |  | VR | VR | 69 | P
StudentB11 |  |  |  |  | 0 | E |  |  |  |  |  |  |  |  |  |  | AB | AB |  |  |  |  |  |  |  |  |  |  | AB | AB |  |  |  |  | AB | AB |  |  |  |  |  |  |  |  |  |  |  |  | AB | AB | AB | AB | VR | VR | AB | AB
StudentB12 | 57 | C5 |  |  |  |  |  |  |  |  |  |  | 57 | C5 |  |  |  |  |  |  |  |  |  |  | 77 | A1 |  |  |  |  | 53 | C6 |  |  |  |  | 76 | A1 | 73 | A2 | 65 | B3 |  |  |  |  |  |  | 74 | P |  |  | VR | VR | 71 | P
StudentB13 |  |  | 67 | 3 |  |  |  |  |  |  |  |  | 53 | C6 |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 4 |  |  |  |  | 55 | 5 |  |  |  |  | 64 | B4 |  |  | 67 | 3 |  |  | 75 | 1 | 68 | P |  |  | VR | VR | 71 | P
StudentB14 | 67 | B3 |  |  |  |  | 70 | A2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC | MC |  |  |  |  | MC | MC |  |  |  |  | 67 | B3 | 83 | A1 | 70 | A2 |  |  |  |  |  |  | 78 | P |  |  | VR | VR | 66 | P
StudentB15 |  |  | 53 | 5 |  |  |  |  |  |  | 56 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 6 |  |  |  |  | 65 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | P | 83 | A | VR | VR | 60 | P
StudentB16 | 43 | E8 |  |  |  |  | 61 | B4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | D7 |  |  |  |  | 28 | 9 |  |  |  |  | 67 | B3 | 37 | 9 | 30 | 9 |  |  |  |  |  |  | 46 | U |  |  | VR | VR | 51 | P
StudentB17 |  |  | 50 | 5 |  |  |  |  |  |  |  |  | 37 | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 4 |  |  |  |  | 28 | 6 |  |  |  |  |  |  |  |  | 62 | 4 | 80 | 1 | 55 | 5 | 78 | P |  |  | VR | VR | 70 | P
StudentB18 |  |  | 57 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 6 |  |  |  |  |  |  | MC | MC |  |  | 18 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 | P | 80 | A | VR | VR | 50 | P
StudentB19 | 53 | C6 |  |  |  |  | 36 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | C5 |  |  |  |  | 28 | 9 |  |  |  |  | 90 | A1 | 62 | B4 | 45 | D7 |  |  |  |  |  |  | 82 | P |  |  | VR | VR | 77 | P
StudentB20 | 50 | C6 |  |  |  |  | 31 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | C6 |  |  |  |  | 48 | D7 |  |  |  |  | 62 | B4 | 80 | A1 | 45 | D7 |  |  |  |  |  |  | 44 | U |  |  | VR | VR | 73 | P