fill empty cells from above cells

[lezawang]

Hi

I have blank cells in the sheet below (please see the link). To fill these blank cells, I want to copy the content of the cells above.
In the original sheet, I just highlighted the first few cells with yellow for you. Thank you very much

Example


[TABLE="width: 500"]
<tbody>[TR]
[TD]contract[/TD]
[TD]key[/TD]
[TD]name[/TD]
[TD]location[/TD]
[TD]date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]john[/TD]
[TD]1 city[/TD]
[TD]1-1-2000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1 city[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10[/TD]
[TD]mary[/TD]
[TD]city a[/TD]
[TD]1-10-2010[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]city a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]100[/TD]
[TD]alex[/TD]
[TD]city b[/TD]
[TD]9-9-2009[/TD]
[/TR]
</tbody>[/TABLE]

The result should be

[TABLE="width: 500"]
<tbody>[TR]
[TD]contract[/TD]
[TD]key[/TD]
[TD]name[/TD]
[TD]loction[/TD]
[TD]date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]john[/TD]
[TD]1 city[/TD]
[TD]1-1-2000[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]john[/TD]
[TD]1 city[/TD]
[TD]1-1-200[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10[/TD]
[TD]mary[/TD]
[TD]city a[/TD]
[TD]1-10-2010[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10[/TD]
[TD]mary[/TD]
[TD]city a[/TD]
[TD]1-10-2010[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]100[/TD]
[TD]alex[/TD]
[TD]city b[/TD]
[TD]9-9-2009[/TD]
[/TR]
</tbody>[/TABLE]

The original sheet can be found here:

https://drive.google.com/file/d/1c641_Eq1JMKkYCUQ_-nvRecSK-DC0xCH/view?usp=sharing

 

[Joe4]

See here for instructions on how to do this: https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html

 

[RoryA]

Select the data, press f5, click the Special button and choose Blank cells from the options, then press OK. Now type an = sign, press the Up arrow and then Ctrl+Enter.

 

[lezawang]

Thank you all for the help. It did work perfectly. Thank you.