Student Gender  Cat Room
-------------------------
Anna    F       a   101
Paul    M       b   101
Sara    F       c   102
Mark    M       d   102
Ella    F       a   101
Aaron   M       b   101
Gina    F       c   102
Daniel  M       d   102

={A1:D1;
 FILTER(SORT(A2:D, 3, 1, 4, 1, 2, 1), MOD(ROW(A2:A), 2));
 FILTER(SORT(A2:D, 3, 1, 4, 1, 2, 1), MOD(ROW(INDIRECT("A1:A"&ROWS(A2:A))), 2))}