12 Replies Latest reply: Oct 12, 2015 1:31 AM by kushal chawda RSS

    Work in to 1 Excel

    Kenny Hua

      Hello,

       

      Actually I need to work on a excel. Something like that:

       

      Excel:

      YearInformation 1Information 2

      2000

      A1B1
      2000A2B3
      2000A4B2
      2001A6B7
      2002A8B9
      2002A9B10

       

      I would like to transform this excel into a QVD like that:

       

      QVD:

      YearInformation 1Information 2
      2000A1B1
      2000A2B3
      2000A4B2
      2001A6B7
      2001A1B1
      2001A2B3
      2001A4

      B2

      2002A9B10
      2002A6B7
      2002A1B1
      2002A2B3
      2002A4B2
      2002A8B9

      "Information 1" and "Information 2" are random values.

       

      Regards