Replacing Zeros with Avg from other rows

[RichardFL]

Thank you all for your ideas and replies. Greatly appreciate it.

I will test, Ivan’s workflow seems to be the simplest and easiest to implement.

I greatly appreciate ideas for my other thread:

Replacing missing values with value from different row

In the table below, some rows have items with missing weight value. I need to replace missing value by getting the item’s weight from a row where it is not missing. How can I do this using knime, “Missing Value” node did not help… Thanks! [missingValues]

Thanks!