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

    Can multiple cell values be combined into a single cell?



      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




      234                 1)bbb


      456                 1)ddd