You can try this formula:
=LET(x; SORT(FILTER(A2:F7;C2:C7 <> "No Progress");3;TRUE); y; BYROW(CHOOSECOLS(x;3); LAMBDA(r;SPLIT(r;" "))); CHOOSECOLS(CHOOSEROWS(SORT(HSTACK(x;y);8;FALSE);{1;2;3});{1;3}))
Sample Output:
Reference:
Filter
Sort