2 Replies Latest reply: Jan 4, 2016 1:01 PM by Michael Tarallo RSS

    Reading data tables left to right?



      I need to read in data from left to right as opposed to top to bottom from an Excel spreadsheet.


      For example the headers "Forecasted Target" and "Actual Target" are down the left hand side i.e A1 then A2 with then the results for every week going from left to right ie. Week 1 A1, Week 2 B2 etc.


      To make things more complicated I have more than one table on each sheet, so need to make Qlik separate these tables when it reads in... is this possible?