Hello,

I am trying to write formula for the following need:

Column A

Row 1 Test 1
Row 2
Row 3
Row 4 Test 2
Row 5
Row 6 Test 3

I want to write a formula that will automatically copy the previous cell if the current cell is blank.

The Final Result should be:

Row 1 Test 1
Row 2 Test 1
Row 3 Test 1
Row 4 Test 2
Row 5 Test 2
Row 6 Test 3

I have uploaded an excel sheet with 2 tabs "Problem" and " Desired Solution" for better understnding