Loop Until Two Empty Or Blank Rows - Excel Templates | Excel Add-ins and Excel Help with formulas a

My source has empty rows throughout the sheet (which can't be sorted). Is there anyway to loop until it hits 2 consecutive empty rows? This stops when it hits 1 empty row.

www.ozgrid.com