Find cumulative averages

Hello all,
In excel i have a list of dates and names in cols a and c,related data in cols v,w,x,y is it possible to find a running average for this data and place the results as follows
Average col v in col aq
Average col w in col ar
Average col x in col as
Average col y in col at
Some names have no data available,see attached worksheet.The lists are very long so a macro would be the ideal solution.Many thanks for any help given.