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

    Repivot Excel Data in Load Script?

    Steven Bain

      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?

       

      Cheers,

       

      Steve.