5 Replies Latest reply: Mar 21, 2013 11:51 AM by Philipp Leimgruber RSS

    From row to column

      Hello

       

      I have a problem to solve where might someone is able to give me a hint.

       

      Current situation (Example):

       

      ItemCode     /     Manufacturer      /    ManufacturerOrderCode

      1111111               AAA                         XY2A

      1111111               BBB                         Z3ZZ

      1111111               CCC                         1XYA

      2222222               HHH                         L1LL

      2222222               GGG                        L1LL

      3333333               ZZZ                         Z4Z3Z

       

       

       

      What i need at the end:

       

      ItemCode          Manufacturer1        ManufacturerOrderCode1     Manufacturer2        ManufacturerOrderCode2     Manufacturer3        ManufacturerOrderCode3

      1111111            AAA                         XY2A                                   BBB                    Z3ZZ                                   CCC                         1XYA

      2222222            HHH                         L1LL                                    GGG                    L1LL

      3333333            ZZZ                         Z4Z3Z

       

       

      It means I would like to get for each Manufacturer and ManufacturerOrderCode an extra column instead of a new row.

       

      Thanks in advance

       

      BR