Convert Blanks

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.
  2. Within the space where options are written onto the Excel workbook, make changes on the row showing If Blank. (Default value is #N/A)

Notes:

  1. Notice that some values will be empty strings (which seem like blanks in the imported data).