3 Replies Latest reply on Oct 1, 2012 4:29 PM by Alex Kerin

    Concatenate Unique Rows

    Anthony Chou

      Hello All,

       

      I'm trying to create a calculated field that combines the unique entries of a row. For example:

       

      Object 1: A

                     A

                     B

                     C

      Object 2: B

                     B

                     C

       

      I'm trying to make a new column that returns "A,B,C" for Object 1 and "B,C" for Object 2.

       

      Any ideas to go about this will be greatly appreciated. Thank you!

       

      -Anthony