Moving empty cells up

First mark the lines that have Valies in the first three columns but no date for later deletion.

Use missing values node to replace missing for first two columns with the previous value.

Do the same with the type of leave colum, yes then enties will go to the wrong line.

Delete the previous marked lines.

In the missing values node the settings look like this but use the previous row instead of moving average.

1 Like