Awesome! Thanks a lot! Quick follow up question...

Ive set up the worksheet to have the dissagregated rows below the initial rows so that the worksheet looks as follows:


Name Grade Class Score 1 Score 2 Score 3
Student 1 6th b 100% 95% 80% b1
Student 2 7th a 100% 100% 100% a1
Student 3 7th b 75% 90% 95% b2
Student 4 6th a 85% 85% 100% a2
Student 5 8th a 95% 70% 95% a3
Student 6 6th b 100% 80% 95% b3
Student 7 8th b 95% 70% 85% b4
Student 8 8th b 95% 80% 85% b5

Dissagregated by Class
Class A Averages: 93% 85% 98%
Student 2 7th a 100% 100% 100%
Student 4 6th a 85% 85% 100%
Student 5 8th a 95% 70% 95%





Class B Averages: 93% 83% 88%
Student 1 6th b 100% 95% 80%
Student 3 7th b 75% 90% 95%
Student 6 6th b 100% 80% 95%
Student 7 8th b 95% 70% 85%
Student 8 8th b 95% 80% 85%

Naturally there are spaces in between Class A and Class B since I have to leave enough room for all students, but not all spaces will neccesarily be filled. Is there a way to use conditional formatting to have excel automatically shrink all empty rows to size zero so that the large gaps do not appear? If not, any other recommendations?

Thanks ahead of time again