I use Excel to create an invoice using questions. The user answers the
questions and using IF statements options are added to the invoice. The only
problem is the invoice will have empty spaces between various options because
the formula is in the cell but that option was not selected. How do I get
the information to shift up and fill the cells