Chord diagram from raw data

[OnDaRoXx]

Hi all,

I am trying to represent relationships between my data using a Chord Diagram and unfortunately I can't come up with a solution. Here is my problem description:

I have a table of people who were in different places I now want to show the location and the NUMBER of people who share the locations. The following example data:

Name		Place
Person A		X
Person A		Y
Person A		V
Person B		V
Person B		Y
Person B		X
Person B		Z
Person C		X
Person C		Z

Thank you for your help!

[OnDaRoXx]

Thank you very much!

[lbendlin · Accepted solution]

see attached. Note the Power Query transforms.