How do I pivot this data for a chord chart?

I'm trying to pivot some data so that it can feed into a chord chart but I'm not quite sure what to do. I'm trying to find each group that overlaps with other groups and how often they overlap. Ultim...