Variable Column Headers

Input: Excel files with fixed number of columns but variable column headers.

Download sample input files here

Goal: Setup a workbook formula that pulls the data from all the sample files and puts it at one place.


  1. Use the UI DataFromExcel.SK to setup the import from the sample files by using Column Numbers instead of Column Headers.