Do you need the whole row to shift left if the year was entered into B? Is there other data?
If shifting left is okay, you could hightlight the range, hit F5, choose Special, choose Blanks, then goto Cell under Home tab and delete cells, shifting left.
If not, you could apply a short VB script.
That code goes in VB editor. Alt+F11, Insert, New Module, paste code. Adjust range of cells if too big or too small. Close that window.
Call macros with Alt+F8
That short piece of script just runs down a2:a25000, looks for blank cells, when it finds one, copies the adjacent cell into it, and clears that cell.
Bookmarks