Help....formula

[lee009]

REF NO	ADRESS	RPT NO	TYPE
17-65973	123 MAIN	17-09039	ARR
		17-09039	ARR

<tbody>
</tbody>

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