Excel 2003

Hi to all,

So this is the problem:
i’ve got a Transpose formula that transposes 8 lines to 8 columns. i need to repeat the formula each 8 rows.. like this:

=TRANSPOSE(A9:A16)
=TRANSPOSE(A17:A24)
=TRANSPOSE(A25:A32)

and so on.. but with the click and drag Excel increases +1 in the A’s.. i need it to increase +8.

something like this:
=TRANSPOSE(A17(+8):A24(+8))
=TRANSPOSE(A25(+8):A32(+8))

is there any way to do this? 🙂

thank you for your help!