Populate several consecutive missing values based on previous weeks value

[cgalea]

Hi Everyone,

Does anyone know how to fill in one or more consecutive missing values in a specific week with values taken from the previous week. Appreciate any help you can provide!!

[Sebastiaandb]

Hi @cgalea,

Here you go!

Greetings,

Seb

[Sebastiaandb]

Hi @cgalea ,

And here a different version that leaves row 9 and 10 null() if it's empty (like your example haha). I guess you want the first solution but i might be wrong :-).

Greetings,

Seb