I have a list of data in which I would like to fill in the gaps. Is this
possiable?

I have age in years in A2 to A100 then data in colums in 5 year gaps (eg B2
has data then B7 then B12 etc) all incremental. I would like to fill in the
gaps belween giving me data B2, B3, B4... to B100.

How can I fill in the gaps whilst still making sure my 5 year results are
left.


Simple example below
age Result
45 20
46
47
48
49
50 30
51
52
53
54
55 50


Many Thanks for any help