Exclude Blank Rows With Array

Modify the array entered formula in F2 as follows:

Formula:

=IF(ROWS(F$1:F1)>COUNT(A$2:A$13),"",INDEX(A$2:A$13,SMALL(IF(A$2:A$13<>"",ROW($A$1:$A$12)-MIN(ROW(A$1:A$12))+1),ROWS(A$1:A1))))

Once activated, by simultaneously pressing Ctrl, Shift and Enter while F2 is still in edit mode, copy down to F9. After a new row one is inserted in the spreadsheet the formula will still display the correct number which the Index/Match formulas in the corresponding columns will use. To see how the formula handles the additional row run Evaluate Formula from the Formulas tab.
Let us know if you have any questions.