Replacing missing values with nearest known

Thank you, this works for me. The only issue might be in cases when there are multiple rows at the begging or end (e.g. A2:A3 | A29:A30) with missing values