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

contract	key	name	location	date
1	2	john	1 city	1-1-2000
			1 city
2	10	mary	city a	1-10-2010
			city a
3	100	alex	city b	9-9-2009

<tbody>
</tbody>

The result should be

contract	key	name	loction	date
1	2	john	1 city	1-1-2000
1	2	john	1 city	1-1-200
2	10	mary	city a	1-10-2010
2	10	mary	city a	1-10-2010
3	100	alex	city b	9-9-2009

<tbody>
</tbody>

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.