I have two data sets which I need to merge.
1) demographic data (=one ID per row)
2) Up to 5 duplicates of each ID with different entries per row.
Now I can't just delete the duplicates in order to merge the sets as each entry in (2) is important. Also,the data is quite larger...