Help! How do I roll forward the latest value

Hi,    I have a set of data carrying a value each year, by different locations; the value could be different, too.  Since the value only comes in once per year on a specific month, however, I need...