Pivot table?
www.excelcampus.com/pivot-tables/compare-lists-with-pivot-table/
This Zero Hedge article gives some additional insight into the 4 am media coordination effort:
"A little over a year ago, the deep-state graced the world with Propornot. Thanks to them, 2017 became the year of fake news. Every news website and opinion column now had the potential to be linked to the Steele dossier and Trump collusion with Russia. Every journalist was either with us or against us. Every one that was against us became Russia's trolls. …
In early March 2015, Ukrainian Information Policy designer Joel Harding laid out what to expect going forward in the following statements: "In military IIO operations center on the ability to influence foreign audiences, US, and global audiences, and adversely affect enemy decision making through an integrated approach. Even current event news is released in this fashion. Each portal is given messages that follow the same themes because it is an across the board mainstream effort that fills the information space entirely when it is working correctly.
www.zerohedge.com/news/2018-01-25/propornot-unmasked