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.

Hint:

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