Autofill alternative for non sequential numbers

You can try a formula like this:

If your tables don't have a Header Row (as in your description):

In A1 of Table 2, filled down:

= INDEX(Table 1::A,QUOTIENT(ROW()−1,2)+1)

If your tables have a Header Row (as is common in Numbers):

In A2 of Table 2-1, filled down:

=INDEX('Table 1-1'::A,QUOTIENT(ROW(),2)+1)

More on INDEX here:

INDEX – Apple Support (MY)

More on QUOTIENT here:

QUOTIENT – Apple Support (MY)

Once you've got the values the way you want them in the second table you can "remove" the formulas by selecting the column, command-c to copy, Edit > Paste Formula Results.

SG

In the second column you can try something like this:

In B2, filled down:

=OFFSET(Table 1::A$1,QUOTIENT(ROW(),2),MOD(ROW(),2)+1)

In A2, filled down, I have as above:

=INDEX(Table 1::A,QUOTIENT(ROW(),2)+1)

In A1 one could also use:

=OFFSET(Table 1::A$1,QUOTIENT(ROW(),2),0)

More on functions here:

OFFSET - Apple Support

MOD - Apple Support

SG

SGIII wrote:

In A1 one could also use:

=OFFSET(Table 1::A$1,QUOTIENT(ROW(),2),0)

Meant to write:

In A2, filled down, one could also use...

=OFFSET(Table 1::A$1,QUOTIENT(ROW(),2),0)

SG