Help....formula

[lee009]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]REF NO
[/TD]
[TD]ADRESS
[/TD]
[TD]RPT NO
[/TD]
[TD]TYPE
[/TD]
[/TR]
[TR]
[TD]17-65973
[/TD]
[TD]123 MAIN
[/TD]
[TD]17-09039
[/TD]
[TD]ARR
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]17-09039
[/TD]
[TD]ARR
[/TD]
[/TR]
</tbody>[/TABLE]

Hello,

I am having difficulty with a spreadsheet. I have thousands of rows of data, similar to what's above. I want to be able to copy into blank cells if there is data in the row above. So in the example above, I'd like the two blank cells to be the same as the cells above.

 

[Joe4]

They can be populated pretty easily with the values from above.
See: https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html