Extra Data Columns

Input: Excel files with blank or redundant data columns.

Download sample input file here

Download file with redundant data columns here

Goal: Setup a workbook formula that pulls the data from the sample file as well as the additional data file with redundant data columns.


  1. Use the UI DataFromExcel.SK to setup the import from the sample input file.
  2. Change the "RegionDown.SK(A1:G1)" in the formula to "RegionDown.SK(A1:AA1)"
  3. Run the file on the second file with extra columns to extract the desired result.