7 Replies Latest reply: May 2, 2012 12:10 PM by brandon breitling RSS

    Merging rows of fields based on uniqueness of another

      Hi community,


      I have two fields from the same table A, and B.  I want to make them 1 to 1 so that one row of A has only 1 row of B.


      If there are more than 1 row of B, I would like them all to be put into one row. 


      We could call this field C and it would then match 1 to 1 to A.


      Any ideas?