Hi,
In the column A, I have values with a few blanks. I need to be able to copy to the blanks, the value that was there in the cell above.
For example, if I have something like....
A 1 aa 2 3 4 bb 5 6 cc 7 dd 8 9
I will need it to look like,
A 1 aa 2 aa 3 aa 4 bb 5 bb 6 cc 7 dd 8 dd 9 dd
Please help. Thanks!
Bookmarks