You can use table calcs as filters to control that.
LAST() = 0 will get you the last value in a string of table-calc computed values.
IF last() = 0 then [Expected calc] END
It might take some playing around to get it all to work the way you need, but the components are there to do what you want.
Also you can put another table calc as a filter to eliminate rows with no values. (Or to display rows that have a value.)
If you're just looking for ideas to get you in the right direction, there it is.
But if you need help with this, upload a sample workbook and I'll work with you on it.