Data Imputation

[Raj]

I have data where i want to replace the blank with average of next 5 values

and the filling should start with bigger values first such as it should first fill for 2002 then 2001 and then 2000 so it considers new values as well in the calculation

for eg as 2000 is blank it should take average of new 2001, new 2002,, 2003, 2004 and 2005 

Year Price
2000
2001
2002
2003 68
2004 73
2005 74
2006 50
2007 51
2008 52
2009 59
2010 64
2011 89
2012 60
2013 71
2014 60

thanks in advance

[ed_hayter · Accepted solution]

I reordered the data and imputed with a multi-row formula - i reorder so that we fill 2002 first before 2001

[Raj · Accepted solution]

@ed_hayter  thanks for help