Spreadsheet: 685484d1594038035-data-sort-in-groups-better-than-manually-selecting-each-one-data-sort
Sheet: data sort example

Class | Teacher | Student | Marks |  | Class | Teacher | Student | Marks |  |  | Class | Teacher | Student | Sum of Marks
1 | [NAME] | G | 53 |  |  |  |  |  |  |  | 1 | [NAME] | D | 100
4 | Dominic | C | 54 |  |  |  |  |  |  |  | 1 | [NAME] | C | 87
5 | Cabella | F | 55 |  |  |  |  |  |  |  | 1 | [NAME] | F | 86
10 | Holte | G | 55 |  |  |  |  |  |  |  | 1 | [NAME] | E | 81
9 | Fairweather | E | 58 |  |  |  |  |  |  |  | 1 | [NAME] | A | 74
1 | [NAME] | B | 60 |  |  |  |  |  |  |  | 1 | [NAME] | H | 72
9 | Fairweather | F | 63 |  |  |  |  |  |  |  | 1 | [NAME] | B | 60
3 | Latrell | E | 64 |  |  |  |  |  |  |  | 1 | [NAME] | G | 53
5 | Cabella | C | 65 |  |  |  |  |  |  |  | 2 | Playfair | B | 100
10 | Holte | H | 65 |  |  |  |  |  |  |  | 2 | Playfair | E | 92
2 | Playfair | D | 66 |  |  |  |  |  |  |  | 2 | Playfair | A | 81
8 | Buckley | D | 66 |  |  |  |  |  |  |  | 2 | Playfair | F | 80
5 | Cabella | H | 67 |  |  |  |  |  |  |  | 2 | Playfair | G | 79
7 | [NAME] | E | 67 |  |  |  |  |  |  |  | 2 | Playfair | C | 78
6 | Arbuckle | E | 70 |  |  |  |  |  |  |  | 2 | Playfair | H | 71
8 | Buckley | A | 70 |  |  |  |  |  |  |  | 2 | Playfair | D | 66
2 | Playfair | H | 71 |  |  |  |  |  |  |  | 3 | Latrell | C | 91
6 | Arbuckle | G | 71 |  |  |  |  |  |  |  | 3 | Latrell | G | 87
7 | [NAME] | C | 71 |  |  |  |  |  |  |  | 3 | Latrell | B | 86
1 | [NAME] | H | 72 |  |  |  |  |  |  |  | 3 | Latrell | H | 85
4 | Dominic | E | 72 |  |  |  |  |  |  |  | 3 | Latrell | F | 80
6 | Arbuckle | C | 73 |  |  |  |  |  |  |  | 3 | Latrell | D | 75
1 | [NAME] | A | 74 |  |  |  |  |  |  |  | 3 | Latrell | A | 74
3 | Latrell | A | 74 |  |  |  |  |  |  |  | 3 | Latrell | E | 64
9 | Fairweather | A | 74 |  |  |  |  |  |  |  | 4 | Dominic | A | 100
3 | Latrell | D | 75 |  |  |  |  |  |  |  | 4 | Dominic | B | 91
8 | Buckley | E | 75 |  |  |  |  |  |  |  | 4 | Dominic | F | 88
9 | Fairweather | H | 77 |  |  |  |  |  |  |  | 4 | Dominic | D | 81
2 | Playfair | C | 78 |  |  |  |  |  |  |  | 4 | Dominic | E | 72
2 | Playfair | G | 79 |  |  |  |  |  |  |  | 4 | Dominic | C | 54
2 | Playfair | F | 80 |  |  |  |  |  |  |  | 5 | Cabella | D | 100
3 | Latrell | F | 80 |  |  |  |  |  |  |  | 5 | Cabella | B | 90
5 | Cabella | E | 80 |  |  |  |  |  |  |  | 5 | Cabella | G | 87
7 | [NAME] | G | 80 |  |  |  |  |  |  |  | 5 | Cabella | A | 87
1 | [NAME] | E | 81 |  |  |  |  |  |  |  | 5 | Cabella | E | 80
2 | Playfair | A | 81 |  |  |  |  |  |  |  | 5 | Cabella | H | 67
4 | Dominic | D | 81 |  |  |  |  |  |  |  | 5 | Cabella | C | 65
8 | Buckley | B | 82 |  |  |  |  |  |  |  | 5 | Cabella | F | 55
9 | Fairweather | D | 82 |  |  |  |  |  |  |  | 6 | Arbuckle | B | 100
10 | Holte | C | 82 |  |  |  |  |  |  |  | 6 | Arbuckle | A | 93
8 | Buckley | F | 83 |  |  |  |  |  |  |  | 6 | Arbuckle | D | 92
3 | Latrell | H | 85 |  |  |  |  |  |  |  | 6 | Arbuckle | F | 87
7 | [NAME] | H | 85 |  |  |  |  |  |  |  | 6 | Arbuckle | C | 73
9 | Fairweather | B | 85 |  |  |  |  |  |  |  | 6 | Arbuckle | G | 71
10 | Holte | F | 85 |  |  |  |  |  |  |  | 6 | Arbuckle | E | 70
1 | [NAME] | F | 86 |  |  |  |  |  |  |  | 7 | [NAME] | A | 100
3 | Latrell | B | 86 |  |  |  |  |  |  |  | 7 | [NAME] | F | 98
7 | [NAME] | B | 86 |  |  |  |  |  |  |  | 7 | [NAME] | B | 86
7 | [NAME] | D | 86 |  |  |  |  |  |  |  | 7 | [NAME] | D | 86
1 | [NAME] | C | 87 |  |  |  |  |  |  |  | 7 | [NAME] | H | 85
3 | Latrell | G | 87 |  |  |  |  |  |  |  | 7 | [NAME] | G | 80
5 | Cabella | A | 87 |  |  |  |  |  |  |  | 7 | [NAME] | C | 71
5 | Cabella | G | 87 |  |  |  |  |  |  |  | 7 | [NAME] | E | 67
6 | Arbuckle | F | 87 |  |  |  |  |  |  |  | 8 | Buckley | H | 100
9 | Fairweather | C | 87 |  |  |  |  |  |  |  | 8 | Buckley | G | 95
10 | Holte | E | 87 |  |  |  |  |  |  |  | 8 | Buckley | C | 88
4 | Dominic | F | 88 |  |  |  |  |  |  |  | 8 | Buckley | F | 83
8 | Buckley | C | 88 |  |  |  |  |  |  |  | 8 | Buckley | B | 82
5 | Cabella | B | 90 |  |  |  |  |  |  |  | 8 | Buckley | E | 75
3 | Latrell | C | 91 |  |  |  |  |  |  |  | 8 | Buckley | A | 70
4 | Dominic | B | 91 |  |  |  |  |  |  |  | 8 | Buckley | D | 66
2 | Playfair | E | 92 |  |  |  |  |  |  |  | 9 | Fairweather | G | 98
6 | Arbuckle | D | 92 |  |  |  |  |  |  |  | 9 | Fairweather | C | 87
10 | Holte | D | 92 |  |  |  |  |  |  |  | 9 | Fairweather | B | 85
6 | Arbuckle | A | 93 |  |  |  |  |  |  |  | 9 | Fairweather | D | 82
8 | Buckley | G | 95 |  |  |  |  |  |  |  | 9 | Fairweather | H | 77
7 | [NAME] | F | 98 |  |  |  |  |  |  |  | 9 | Fairweather | A | 74
9 | Fairweather | G | 98 |  |  |  |  |  |  |  | 9 | Fairweather | F | 63
1 | [NAME] | D | 100 |  |  |  |  |  |  |  | 9 | Fairweather | E | 58
2 | Playfair | B | 100 |  |  |  |  |  |  |  | 10 | Holte | B | 100
4 | Dominic | A | 100 |  |  |  |  |  |  |  | 10 | Holte | A | 100
5 | Cabella | D | 100 |  |  |  |  |  |  |  | 10 | Holte | D | 92
6 | Arbuckle | B | 100 |  |  |  |  |  |  |  | 10 | Holte | E | 87
7 | [NAME] | A | 100 |  |  |  |  |  |  |  | 10 | Holte | F | 85
8 | Buckley | H | 100 |  |  |  |  |  |  |  | 10 | Holte | C | 82
10 | Holte | A | 100 |  |  |  |  |  |  |  | 10 | Holte | H | 65
10 | Holte | B | 100 |  |  |  |  |  |  |  | 10 | Holte | G | 55
 |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  | 6227