Replace nulls in a series

trying to replicate a value to nulls in a series - so the 8 will go to the next nulls till 9 to the next nulls to 10…and so on.

holy crap took a shot in the dark and it worked!!

solves this issue with excel
image

2 Likes

@AdamHamilton other possible approaches…

replaceNull1.dyn (8.4 KB)

replaceNull2.dyn (14.2 KB)

1 Like