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.
- Use the UI DataFromExcel.SK to select the first range of data in the input file.
- Select the option to Discard Blank Rows in Selection in the UI