Spreadsheet: 538595d1505737251-when-sorting-a-table-the-sort-isnt-holding-example
Sheet: Z2 Q1_Q4

 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average
 | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18 | #19 | #20 | #21 | #22 | #23 | #24 | #25
1 | 5 | 9 | 7 | 9 | 10 | 9 | 10 | 5 | 9
2 | 3 | 7 | 5 | 9 | 7 | 9 | 7 | 3 | 7
3 | 4 | 7 | 5 | 5 | 10 | 5 | 10 | 4 | 7
4 | 6 | 1 | 4 | 1 | 9 | 1 | 9 | 6 | 1
5 | 8 | 7 | 3 | 3 | 9 | 3 | 9 | 8 | 7
6 | 7 | 7 | 6 | 6 | 7 | 6 | 7 | 7 | 7
7 | 6 | 1 | 5 | 6 | 1 | 6 | 1 | 6 | 1
8 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 1 | 2
9 | 10 | 10 | 7 | 3 | 9 | 3 | 7 | 3 | 9
10 | 9 | 7 | 5 | 9 | 7 | 9 | 7 | 9 | 7
11 | 5 | 7 | 5 | 5 | 10 | 5 | 10 | 5 | 7
12 | 1 | 1 | 4 | 1 | 9 | 1 | 9 | 1 | 1
13 | 3 | 7 | 3 | 3 | 9 | 3 | 9 | 3 | 7
14 | 5 | 7 | 5 | 5 | 10 | 5 | 10 | 5 | 7
 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average
 | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18 | #19 | #20 | #21 | #22 | #23 | #24 | #25
1 | 5 | 9 | 7 | 9 | 10 | 5 | 9 | 7 | 9 | 10 | 5 | 9 | 7 | 9 | 10 | 5 | 9 | 7 | 9 | 10 | 5 | 9 | 7 | 9 | 10
2 | 3 | 7 | 5 | 9 | 7 | 3 | 7 | 5 | 9 | 7 | 3 | 7 | 5 | 9 | 7 | 3 | 7 | 5 | 9 | 7 | 3 | 7 | 5 | 9 | 7
3 | 4 | 7 | 5 | 5 | 10 | 4 | 7 | 5 | 5 | 10 | 4 | 7 | 5 | 5 | 10 | 4 | 7 | 5 | 5 | 10 | 4 | 7 | 5 | 5 | 10
4 | 6 | 1 | 4 | 1 | 9 | 6 | 1 | 4 | 1 | 9 | 6 | 1 | 4 | 1 | 9 | 6 | 1 | 4 | 1 | 9 | 6 | 1 | 4 | 1 | 9
5 | 8 | 7 | 3 | 3 | 9 | 8 | 7 | 3 | 3 | 9 | 8 | 7 | 3 | 3 | 9 | 8 | 7 | 3 | 3 | 9 | 8 | 7 | 3 | 3 | 9
6 | 7 | 7 | 6 | 6 | 7 | 7 | 7 | 6 | 6 | 7 | 7 | 7 | 6 | 6 | 7 | 7 | 7 | 6 | 6 | 7 | 7 | 7 | 6 | 6 | 7
7 | 6 | 1 | 5 | 6 | 1 | 6 | 1 | 5 | 6 | 1 | 6 | 1 | 5 | 6 | 1 | 6 | 1 | 5 | 6 | 1 | 6 | 1 | 5 | 6 | 1
8 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1
9 | 7 | 3 | 9 | 3 | 7 | 3 | 9 | 3 | 7 | 3 | 10 | 7 | 3 | 9 | 3 | 7 | 3 | 9 | 3 | 7 | 3 | 10 | 10 | 10 | 10
10 | 9 | 7 | 5 | 9 | 7 | 9 | 7 | 5 | 9 | 7 | 9 | 7 | 5 | 9 | 7 | 9 | 7 | 5 | 9 | 7 | 9 | 7 | 5 | 9 | 7
11 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10
12 | 1 | 1 | 4 | 1 | 9 | 1 | 1 | 4 | 1 | 9 | 1 | 1 | 4 | 1 | 9 | 1 | 1 | 4 | 1 | 9 | 1 | 1 | 4 | 1 | 9
13 | 3 | 7 | 3 | 3 | 9 | 3 | 7 | 3 | 3 | 9 | 3 | 7 | 3 | 3 | 9 | 3 | 7 | 3 | 3 | 9 | 3 | 7 | 3 | 3 | 9
14 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10 | 5 | 7 | 5 | 5 | 10
 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average
 | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18 | #19 | #20 | #21 | #22 | #23 | #24 | #25
1 | 9 | 10 | 5 | 9 | 7 | 9
2 | 9 | 7 | 3 | 7 | 5 | 9
3 | 5 | 10 | 4 | 7 | 5 | 5
4 | 1 | 9 | 6 | 1 | 4 | 1
5 | 3 | 9 | 8 | 7 | 3 | 3
6 | 6 | 7 | 7 | 7 | 6 | 6
7 | 6 | 1 | 6 | 1 | 5 | 6
8 | 2 | 1 | 1 | 2 | 1 | 2
9 | 3 | 7 | 3 | 9 | 3 | 7
10 | 9 | 7 | 9 | 7 | 5 | 9
11 | 5 | 10 | 5 | 7 | 5 | 5
12 | 1 | 9 | 1 | 1 | 4 | 1
13 | 3 | 9 | 3 | 7 | 3 | 3
14 | 5 | 10 | 5 | 7 | 5 | 5
 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average
 | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18 | #19 | #20 | #21 | #22 | #23 | #24 | #25
1 | 9 | 10 | 5 | 9 | 7 | 9
2 | 9 | 7 | 3 | 7 | 5 | 9
3 | 5 | 10 | 4 | 7 | 5 | 5
4 | 1 | 9 | 6 | 1 | 4 | 1
5 | 3 | 9 | 8 | 7 | 3 | 3
6 | 6 | 7 | 7 | 7 | 6 | 6
7 | 6 | 1 | 6 | 1 | 5 | 6
8 | 2 | 1 | 1 | 2 | 1 | 2
9 | 3 | 7 | 3 | 9 | 3 | 7
10 | 9 | 7 | 9 | 7 | 5 | 9
11 | 5 | 10 | 5 | 7 | 5 | 5
12 | 1 | 9 | 1 | 1 | 4 | 1
13 | 3 | 9 | 3 | 7 | 3 | 3
14 | 5 | 10 | 5 | 7 | 5 | 5