I am working on the attached spreadsheet which includes the same formula in cells I2:P2. When there are no values in the cells below, the formula is set to output a blank. Is there a way for the display of a cell's results to span across over adjacent cells with null output to the right? In other words, can I get J2 to look like J10 (achieved by deleting the formulas in K10 and L10)? Deleting the formulas is less than ideal, and merging cells is not an option, nor would be resizing the cell / enabling word wrap.
Thanks in advance!