I've got a downloaded tree that I need the blanks filled in
Only sometimes I actually want the blank if the cell above is the last
value in the tree

I know the formulas to create a 'wall of data' with no nulls from pivot
tables and the go to blanks solution but those only work if the columns
have a fixed meaning - i.e. column 5 is always the unit

Problem is these do not work because the # of columns (tree levels) is
random

Using the normal formulas/solutions will continue to add values of the
cell above even if the tree ended at one less column

Any ideas?