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.
- Use the UI DataFromExcel.SK to setup the import from the sample input file.
- Change the "RegionDown.SK(A1:G1)" in the formula to "RegionDown.SK(A1:AA1)"
- Run the file on the second file with extra columns to extract the desired result.