7 Replies Latest reply: May 2, 2012 12:10 PM by Brandon Breitling RSS

Merging rows of fields based on uniqueness of another

Brandon Breitling

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?