6 Replies Latest reply: Oct 8, 2012 5:37 AM by Jairaj Singh RSS

    How I merge Multiple columns into one column??

    Jairaj Singh

      I have following Table :

       

      MonoColorSipmlexDuplex
      1234
      5678
      9101112

       

      Now I want to merge All 4 column into one column name ' Type ' and add one additional column name ' Value ' where I show the sum like following:

       

      Type               Value

      -------             ------------

      Mono            15

      Color             18

      Simplex         21

      Duplex          24

       

      How I got this??