I have a column of information that has some blanks and need a formula to
collapse the rows so there are no blanks. Does anyone know if there a way to
collapse rows that have no information?