Issue:- During excel work, We need to fill values(first upper non-blank cell value) automatically in a blank cell.
Root Cause:-Main issue blank cells are in randomely possition, so symetric or pattern.
1- copy the value of the first cell
2- select the area were the blank cells should be filled
3- Go to Home → find and replace → replace → replace then:
find what: empty
Replace with: past the first cell value “A” for example.
But it will fill “A” in every empty cell.
Note:- Empty cell must be follow immediate upper no-empty cell value.