You're welcome. Glad to help.
Sure. In every
blank cell in the column it puts a formula that retrieves the value that is in the cell
immediately above it.
So if J2 had a value and then several blank cells, those blank cells would now contain these formulas:
J3 would contain =J2
J4 would contain =J3
J5 would contain =J4
etc
To see it in action, instead of just running that code, put your cursor in the code and press F8 until that line has been processed, then have a look at the cells in column J that were originally blank.