I am not sure quite how to begin programming a solution to this problem. I need to take an excel file that has the following headers...
ID1, NAME, ID2, PCPNAME
there are multiple records that have the same ID2.
I need to combine those records so that it would go ID1|ID1, NAME, ID2, PCPNAME...