When loading data from Excel, sometimes spreadsheets are not always straight-forward, in other words, they do not always store data in columns. Instead, I have found that customers will add spaces, transpose columns and rows, add text (not really data), and the like. To overcome these issues, QlikView possesses a wizard, Enable Transformation Step. You can access this from within the QlikView Edit Script > Table Files > select your Excel (xls, or xlsx), then select the Next button. This will expose the Enable Transformation Step button. The Transformation Wizard will guide you on how to restructure or define how QlikView should interpret your spreadsheet data structure. Truth be told, this does take some getting use to, so you might have to run through it more than once to get a feel for what it is attempting to accomplish, then make any necessary enhancements.
Hope this Helps you.
~Greg
.png "Former Employee"){kind=icon}