Calculating relationships in a table

Hi!

I am trying to convert a raw data input of publications and their writers to an output that summarizes how often the different writes have published articles together. Could anyone please provide any help along the way on how to do that?

Please also find the attached example of a typical input and wanted output format.

Best,
Erik