It is going to be very complicated doing this using a repeater field. You will need to re-sort the rows of the repeater multiple times. Here is a guide on sorting repeater fields https://www.advancedcustomfields.com/resources/how-to-sorting-a-repeater-field/
This would be better accomplished using a custom post type for employees and a custom taxonomies for sorting.