Input: Excel files with possibly missing columns of data.
Download sample input files here Sample files
Goal: Setup a workbook formula that pulls the data from all the sample files and puts it at one place. Further, the workbook should give either errors or warning based on which columns are missing.
- 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).