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

**ADDENDUM**:

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.

**ADDENDUM2**:

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

sortEveryNth_1614467369499788.ods

**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

sortEveryNth_dogs.ods

**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.

16147023663391483-1copia.ods