3 Replies Latest reply: Jan 31, 2013 2:28 PM by pappodan RSS

    Loading Hierarchical Excel Sheet

      Hi,

       

      I'm having trouble loading the attached spreadsheet into Qlikview.  It comes in a heirarchical format where the first row is region name, second row is state name, third row is type of unit and the fourth row has both the date header and names of the units, then the rest of the rows contain the data .  If it is possible I would like to have it in the following format in Qlikview:

       

      DateRegionStateUnit Type
      Unit NameMW
      1/1/2008Pacific NorthwestIDPeakingEvander0
      ......WANon-PeakingChehalis0
      ......ORPeakingBeaver72991

       

      Also it would be ideal for me to not have to tweak the spreadsheet at all, if possible.

       

      Any suggestions would be highly appreciated.