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.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!