title: Building a network graph off Zotero with Excel/Sheets
body: <p>I'm trying to build an authors network graph off of my Zotero bibliography. I've exported the database to .csv and need to edit it before using visualization software like Gephi, Cytoscape, etc.</p>
  
  <p>So, I figure the data needs to be served as:</p>
  
  <pre><code>Column 1 -&gt; Author X
  Column 2 —&gt; All authors who have worked with author X
  </code></pre>
  
  <p>This data would come from my current Authors column, which at the moment is formatted as:</p>
  
  <pre><code>Row1: Author X; Author Y; Author Z
  Row2: Author A; Author B; Author C
  Row3: Author X; Author Z; Author B
  ...
  </code></pre>
  
  <p>How can I process this data?</p>