2 Replies Latest reply: Apr 24, 2014 11:57 AM by Josetxo Amonarriz RSS

    Table transformation

    Josetxo Amonarriz

      Hello Community!

       

      I have a table like this:

       

      RowFormula
      BS0500BS0510
      BS0500BS0520
      BS0510240
      BS0510249
      BS0510293
      BS0520242
      BS0520295

       

      And I would like to convert / expand it to this:

       

      Header 1Header 2
      BS0500240
      BS0500249
      BS0500293
      BS0500242
      BS0500295
      BS0510240
      BS0510249
      BS0510293
      BS0520242
      BS0520295

       

      Any help would be highly appreciated!

      Thanks in advance.