If you can, you can insert before columns A: B a service column with value 1 for the first block of six, 2 for the second block of 6, 3 for the third block of 6, and so on.
Once this is done, copy this new block of three columns A, B, C into columns E, F, G, copying columns A to E, B to G and C to F separately
Finally you order the range E-G with sort keys E (primary) and F (secondary), both numeric and ascending
You should eventually get your sort of block of 6 data at a time while keeping the data-index pair
This solution does not force you to use a macro
To automatically generate the sequence of 6 blocks with six one, six two, six three, etc., you can for example in column L row 1 ( L1 () generate the sequence of integers 1,2,3,4,5,6,7,8,9 (this with calc is super easy)
In M1 enter the formula "= INT (L1 / 6.01) e after drag it for all the cells of the M1 column required
Then copy the obtained sequence where you need it.
This is my simulation.
In sheet two I reported the data used for the simulation and the formulas used to generate them
Only the repeated blocks 1-6 I edited them with repeated copy and paste
I have also retag your post adding two tag
This solution seems to me to work without the use of macros, but with a simple macro you can automate the whole process, including the generation of the service column and the final exchange of the index-data columns, not performed here
ADDENDUM3: inserted in sheet 2 column C to automatically generate repeating blocks 1-6 to be copied and pasted as needed
ADDENDUM4: Press the “start sort” button to start sorting.
I understand little or nothing about your structure.
I think it would be better to start from a database coding races, dogs, etc. and build the sheet from that
I therefore limited myself to automating blocks of six as required
It is essential that the table to be sorted is the one you provided me, otherwise the column and row references must be replaced.
I think there is a second solution, perhaps faster to try, but this one seems to work.
The calc file must be saved and reopen to work
ADDENDUM5 In the new attachment, I have added in columns X and Y an example of formulas to immediately and automatically sort the first block of eight times
The proposed formulas are quite simple, but they have the limit that if you copy / paste / drag you will lose the connection with the correct subrange of data to be processed.
However, a macro can automatically create the correct formulas for all loaded tabs.