1. Documentation
  2. Exercises
  3. Import
  4. Excel
  5. Extra Data Columns

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.

Hint:

  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.