Hi All, 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.
Solution:- https://www.youtube.com/watch?v=9M6O5sfKqkk
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.
Then Done
Thanks @Fouad_Abu_Jasser
But it will fill “A” in every empty cell.
Note:- Empty cell must be follow immediate upper no-empty cell value.