Can I create an edge list from affiliate list?

Feb 8, 2014 at 12:33 AM
I have a list of affiliations, vendors and their clients (in Excel):

FUNK Amag
MIKE Amag
GALS Amag
HALEY Amer
IBIT Amer

I want to create a relationship/edge between each vendor that has the same client:

FUNK - MIKE
FUNK - GALS
GALS - MIKE
HALEY - IBIT

(should I also take out duplicates?)

Does anyone know how I can do that?

Thank you in advance,

Chris