Fill empty cells with content of full cells above it

Hallo,

i need help in filling a very large list. My content is in Column H and there are many empty cells in it. I want the empty cells to be filled with the content of the first full cell above it. I am attaching a dummy list to test purposes. There are two ws: how my original list look like and how the result should look like.

Thanks for your help in advance.

P.S. Last cell in my column H contains "µµµ" / Last cell in column

Highlight H1 down as far as you need your list
F5 >> Special >> Blanks
Hit the = sign and then the up arrow one time
Do not press enter, instead, Ctrl + Enter

Originally Posted by jeffreybrown

Highlight H1 down as far as you need your list
F5 >> Special >> Blanks
Hit the = sign and then the up arrow one time
Do not press enter, instead, Ctrl + Enter

...then highlight column H, copy it, then Edit > Paste Special > Values > OK.

Now the formulas are gone leaving values only. The results of this technique give you your described verbal request in post #1, but not your worksheet demonstrated results. Your worksheet showed the string values being numbered sequentially, which is a completely different problem and you didn't state you really wanted that.

Jeff,
thank you very much. Its really like magic. It worked! thanks alot+

thank you Jerry as well

You are most welcome...glad it worked for you

Don't forget to include the added step by JB

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save