Formatting data for co-occurence.

I prob wont answer this because I dont know what a co-occurrence network is.
But FYI

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
Posting an image is pretty useless, the only way to provide working solutions is to test them first and noone wants to retype data you've already entered.