I have three fields called "UniqueID" "Relationship" and "Score".

Relationship:

Self
Boss
Peer
Direct Report
Other
I need to merge the Scores from "Others" and "Peer" into one group labeled "Peers" and I need to merge the "UniqueID" from "Others" and "Peer" into the "UniqueID" for "Peers"

Essentially I want to merge "others" into "Peers"

This seems like it is a easy thing to do but after 2hrs of trying I thought I would ask for help

Thanks

Edited by Capson - 21 Apr 2013 at 5:05pm

Thank you Sastry that gave me what I was hopping for.