2 Replies Latest reply: Jan 23, 2015 2:31 PM by Rupesh Bharadwaj RSS

    How to get a transposed result

      Hi,

       

      I have this table (from excel):  

               

      Customer   SegmentLocal CodeQTA JAN 2015QTE FEB 2015QTE MAR 2015

         AA                                  123                    2                         6                                   2

        BB                                    123                  10                       10                                  20

        BB                                     256                  20                       30                                40   

       

      How can i do to get this result :

       

        Customer       LocalCode       MONTH    QTE

        AA                     123                    1           2             

        AA                     123                    2           6      

        AA                     123                    3           2           

        BB                      256                  1            10

        BB                      256                  2            10

        BB                      256                  3             20

      ...................................

       

      Thanks for your help.