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?