Hi,

You cannot remove blank rows using a formula.

You have to perform one of the following actions:
(1) Delete the blank rows (for example, via filtering); or
(2) Sort the column (this will "push" the blank rows to the bottom).

Both of these options can be automated using VBA if necessary.