5 Replies Latest reply: Nov 14, 2012 2:07 PM by Anand Chouhan RSS

    Repivot Excel Data in Load Script?

      Hiya Guys,


      I have MS Excel data in the format:


      AccountAccount NameJanuaryFebruaryMarch
      1My Account100200350


      To make this useable in QV - how do I Script a re-pivot so the data is loaded as:


      AccountAccount NameMonthAmount
      1My AccountJanuary100
      1My AccountFebruary200
      1My AccountMarch350


      Surely this is fundamentally what QV is used for and this should be straight forward?! - or am I approaching the issue incorrectly?