I have:
Please see below for the desired result:
How to do this in Excel? The method should stop after the final year (i.e. 2029) Thanks.
If your first cell (i.e top row for 2019) is cell D2, try this ...
=IF(D$1>=$B2,IF(MOD(D$1-$B2,$C2) = 0,$A2,""),"")
Just fill down and across.