3 Replies Latest reply: Apr 25, 2014 7:33 AM by Josetxo Amonarriz RSS

    Table transformation

    Josetxo Amonarriz

      Hello Community,

       

      I would like to transform this data table:

       

      Header 1Header 2
      BS001BS002
      BS001BS003
      BS002BS004
      BS002246
      BS003BS005
      BS003BS006
      BS005247
      BS005248
      BS004249
      BS004250
      BS006251
      BS006252
      BS006253

       

      onto this one:

       

      Header 1Header 2
      BS001249
      BS001250
      BS001246
      BS001247
      BS001248
      BS001251
      BS001252
      BS001253
      BS002249
      BS002250
      BS002246
      BS003247
      BS003248
      BS003251
      BS003252
      BS003253
      BS004249
      BS003250
      BS005247
      BS005248
      BS006251
      BS006252
      BS006

      253

       

      Any help will be highly appreciated,