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.
- Use the UI DataFromExcel.SK to setup the import from the sample files.
- Within the space where options are written onto the Excel workbook, make changes on the row showing If Blank. (Default value is #N/A)
- Notice that some values will be empty strings (which seem like blanks in the imported data).