Hi everyone.
I am using the following array formula to compact a list by removing the open rows.
=IFERROR(INDEX(HN4:HN5740, SMALL(IF((HN4:HN5740)="","", ROW(HN4:HN5740)-MIN(ROW(HN4:HN5740))+1), ROW(HN1))),"")
It works brilliantly on a short list.
However, my list is actually 7300 rows...