3 Replies Latest reply: Jul 13, 2014 4:47 PM by Anand Chouhan RSS

    Can multiple cell values be combined into a single cell?


      Hi,

       

      I have a requirement as follows:

       

      Col A     Col B

      123         aaa

      234         bbb

      123         ccc

      456         ddd

      123         eee

       

      I need to get the result as below in single cell in separate lines(col B) i.e aaa,ccc and eee which belongs to 123 must be displayed in a single cell one below the other as shown below.

       

      A                        B

      123                 1)aaa

                             2)ccc

                             3)eee

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

      234                 1)bbb

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

      456                 1)ddd