Help to fill down array formula, in intervals

I am trying to speed up mass data entry into a workbook containing multiple sheets.

My reference data is contained in a sheet labeled DC. It has averages in columns that I have been transposing into master data sheet with the following formula

=TRANSPOSE(DC!AF4:AF12)

I am trying to fill down the following formula in the master sheet, but I can't figure out how to have it fill in intervals of 10. I want to be able to enter my data on the DC sheet and have the averages automatically fill on the the master sheet. I have hundreds of lines of data to enter and not having to change the formula for every line would help.

So it should fill as follows.
=TRANSPOSE(DC!AF4:AF12)
=TRANSPOSE(DC!AF14:AF22)
=TRANSPOSE(DC!AF24:AF32)

Any help is appreciated.
Lindsay

Hi and welcome to the forum

(have you looked at the picture you uploaded???)

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.