Sorry about taking so long to get back to this, work has been crazy.
The only thing that I can really point to us theis https://www.advancedcustomfields.com/resources/how-to-sorting-a-repeater-field/ which is an example of how to sort repeater fields.
You might also want to look at php usort() https://www.php.net/manual/en/function.usort.php
I can tell you that if I was going to be dealing with data on the order of hundreds of rows that I would not be using a repeater fields. Repeater fields are not really scalable to this degree. I would probably be using a custom post type or some other mechanism for storing this data that would allow easier querying and sorting.
