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.


  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