Enter this formula in cell B1 and fill down as far as necessary. Report back if it works:

=AVERAGE(OFFSET($A$1,(ROW()-1)*10,0,10))