6 Replies Latest reply: Jun 7, 2011 7:20 AM by Anne Duffy RSS

    Transpose  Excel in script load

      Hi Guys,

       

      Hope someone can help, I am in the middle of loading Excel management reports into Qlikview,

       

      There are a few that are formatted incorrectly , at the moment they are formatted like FIG 2 , however I wish for them to be formatted as FIG 1 .

       

      ( Basically all the data Transposed !!) I dont really want to do this in Excel (as the management do not want their logs amended and I'm not really keen on building a mirror log to load)

       

      Doen anyone know if Qlikview has some fancy script that may help ?

       

      Thanks

      A

       

      FIG 1

      Test v3.bmp

       

       

      FIG 2

      test 1v2.bmp