11 Replies Latest reply: Dec 12, 2013 6:26 AM by Swati Tomar RSS

    How I can Tranform a Excel Data

      Hi all,

      I´m new in Qlickview and I have a Excel File with Budget by unit, but the format is something like this

       

      Group_Code     Item_Code     Jan     Feb     Mar     Apr

       

           a0001          XXXXXX          20       15      25       32

       

      I ned this in other format:

       

      Group_Code    Item_Code    Month     Quantity

           a0001         XXXXXX         Jan            20

           a0001         XXXXXX         Feb           15

       

      I ask how I can do this? .

       

      I appreciate your Help