I would like my results to populate one after the other. No blank cells between each result.
That could be
=IFERROR(INDEX(Table1[Order Id],AGGREGATE(15,6,1/(Table1[AFID]=$F$4)/(Table1[Is Refund]=$G$4)*(ROW(Table1[AFID])-ROW(Table1[[#Headers],[AFID]])),(ROW()-ROW(Table3[[#Headers],[AFID]])))),"")
Please see the table on the right attached