Repeating the values from previous row whe a row is all zeros

Hi, and thanks for reading.

I have some assay data that has been delivered with % distributons every 5 metres. The sample interval is every 0.5 m. All the other rows have zeros all the way across. I want to preserve the sample interval so sorting and getting rid of the zero rows does not help.

I'd like to know how to just repeat the values from the previous row if the row is all zeros.

I am attaching a small subset of the file.

Many thanks

GG

I am not 100% sure that I am understanding what you want -- I looked at your sample file, but it's not giving any context for what the end result should look like. Can you expand a little bit on what the data should look like in the end?

Sure,
The rows with all zeros should look the same as the nonzero rows above them until the next nonzero row

so
200 50 10 20 20
200.5 0 0 0 0
201 0 0 0 0
201.5 0 0 0 0
202 0 0 0 0
202.5 0 0 0 0
203 0 0 0 0
203.5 0 0 0 0
204 0 0 0 0
204.5 0 0 0 0
205 80 20 0 0
205.5 0 0 0 0

will look like

200 50 10 20 20
200.5 50 10 20 20
201 50 10 20 20
201.5 50 10 20 20
202 50 10 20 20
202.5 50 10 20 20
203 50 10 20 20
203.5 50 10 20 20
204 50 10 20 20
204.5 50 10 20 20
205 80 20 0 0
205.5 80 20 0 0

Thanks,

I don't think it was quite there but changing B2:F2 to $B2:$F2 did the trick.

Thanks again for the help

Wow,
I know almost nothing about macrros in Excel but I will make a point of understanding how to implement and modify this for other similar problems.

Many thanks