Auto Remove Rows in List

[Niester Rabbit]

I need to figure out how to take columns of information that are produced based on formulas and return other columns that take out the blank rows so all information is consecutive.

See attached. First columns have blank rows. 2nd columns have desired result.

Thank you