Spreadsheet: 685478d1594035705-data-sort-in-groups-better-than-manually-selecting-each-one-data-sort
Sheet: data sort example

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