finding non empty cellsl within a range

Hi I would like to ask if someone can help me. Im trying to find the non empty cell values along my year column and also try to find out the corresponding year the value falls into.

I have attached the excel sheet. I dont do macro by the way just excel formula.

Thank you very much