I would like to copy the first cell to the left of the active cell in a given row that is not blank then copy the contents to the original cell. Then I would like to move onto the next row and repeat. When all the cells to the left of the active cell are blank I would like the function to end.

Below is an example of the the data I am working with. I would like to populate each cell of the "most recent" column with the value of the first cell to the left of it that contains a value. The number of rows will not remain the same.

Month 1 Month 2 Month 3 Month 4 Most Recent
8 7 9
6 5
4 6 7 7


Any help with this would be great. Thank you