Moving empty cells up

[ngumpena]

Hi,

Can someone help me on how can I shift the cells up when the value is missing in the cell?

I am having empty rows and the first thing is I need to move up the cell.

I tried using java snippet and missing rows, but then I couldn’t able to do.

Please suggest

Regards,

[mlauber71]

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.

Replacing missing values with value from different row

In the Missing value node you can use a previous value or a moving average. I think you might be able to combine that with a Group Loop if you want to do this per group. Might also help with your other question. [image]

[ngumpena]

Hi,

Thanks a lot. Its working now