9 Replies Latest reply: May 19, 2016 5:15 AM by anas abbasi RSS

    Manipulating the data into another form in the script editor

    anas abbasi

      Hi All,

       

      I have a data in the following format

       

      Name
      Product

      A

      P1
      AP2
      AP3
      BP4
      BP5
      CP6
      CP7
      CP8
      DP9

       

       

       

      AND AFTER MANIPULATION IT SHOULD COME IN THIS FORMAT..

      NAMEPRODUCT1PRODUCT2PRODUCT3
      AP1P2P3
      BP4P5-
      C

      P6

      P7P8
      DP9--

       

       

      I have been trying approaches but couldn't find a solution.

      If there are 'n' numbers of product in Name 'A' then number of columns should also be 'n'

      No matter how many products are associated with Name 'B'

       

       

       

      Thanks & Regards,

      Anas