One way to get those averages is to use this formula in B1 copied down

=AVERAGE(OFFSET(A$1,(ROWS(B$1:B1)-1)*3,0,3))