Sometimes you might import a file, such as an excel file in which information is missing from a cell. The reason could be that the Excel spreadsheet was set-up as a report instead of an actual spreadsheet. Within the Report Reader we have the option to grab information from previous rows in cases that the information is missing, unfortunately this is not the case with Excel or other import types. Currently if you have this problem you usually have to bring the spreadsheet into IDEA, export it as a text report then use the Report Reader to populate the missing data, this script will save you from having to do this.
