Hi there,
I've been grappling with a problem all afternoon and wonder if someone might be able to help me.
I have data for person relationships where there is a 'duplicate' entry of the reciprocal data row in my file.
| Person ID | Relationship | Related Person ID | Reciprocal Relationship |
| 123 | Parent | 456 | Child |
| 456 | Child | 123 | Parent |
| 789 | Advisor | 888 | Advisee |
| 888 | Advisee | 789 | Advisor |
I need the relationship between Person ID 123 and 456 to appear only once, and the same goes for the relationship between 888 and 789.
The problem is that I don't have a way (currently!) to order them as the records are shown here. If I could, then the solution would be relatively simple, e.g. using the Multi-Row Formula tool.
Can anyone help me?
Any advice would be greatly appreciated!
Rachel
