Need to take the data from the cell below a blank cell and copy to the blank cell above

Hi Excel Experts,

I posted earlier and got a great response, so I am trying again. I need to fill the blank cells in a column with the data that would be in the next cell down. I will always only have one blank, until the end of the column. I need to end up with the column having data in every cell. Say my column is D. D1 has Part1 D2 is blank and D3 has Part2. I need to get Part2 in cell D2, and so on. The spacing of the blanks will not be uniform. Please let me know any further info you may need. And, thank you all again.