Ignore Blank Rows

Input: Excel file with blank rows in data.

Download sample input file here

Goal: Setup a workbook formula that pulls the data from the sample file.

Hint:

  1. Use the UI DataFromExcel.SK to select the first range of data in the input file.
  2. Select the option to Discard Blank Rows in Selection in the UI