12 Replies Latest reply: May 12, 2012 8:07 AM by vikas mahajan RSS

    Transform Rows into Column

    vikas mahajan

      I have following table

       

      Item no          Dimension   Dimension Value

      FDABT001     BRAND        ABZ Group   

      FDABT001     DEPT           Domestic Marketing

      FDABT001     THERSEG    Anti-Helmintic

      I want following Output (Cross Table)

       

       

      ITem no         BRAND       Dept                         THERSEG

      =============================================

      FDABT001     abz group   Domestic Marketing    Anti-Helmintic

       

      Can any one help me for getting this output.

       

      Regards

       

      Vikas MAhajan