Hi there,

I am trying to consolidate a large group of cells (roughly 170k rows in total). The data currently looks like the below:

Current State of Data:

Date Company Location Buyer/Investor Size ($MM)
6/10/2015 DOJO Madness DE 500 Startups 2
6/10/2015 DOJO Madness DE DN Capital 2
6/10/2015 DOJO Madness DE London Venture Partners 2
6/10/2015 DOJO Madness DE March Capital Partners 2
6/10/2015 DOJO Madness DE The Hive 2
6/3/2015 FloSports TX Silicon Valley Bank 3
6/2/2015 upmysport 0 Angel CoFund 2
6/2/2015 SportsLock IL Wicklow Capital 5
6/2/2015 SportsLock IL Robert DuPuy 5

Desired Outcome:

Date Company Location Buyer/Investor Size ($MM)
6/10/2015 DOJO Madness DE 500 Startups, DN Capital, London Venture Partners, March Capital Partners, The Hive 2
6/3/2015 FloSports TX Silicon Valley Bank 3
6/2/2015 SportsLock IL Wicklow Capital, Robert Dupuy 5


The issue:
At the moment, the data set I am using is listing each buyers/investors investment into a company as a separate event and outputting it into a separate row. In reality, DOJO Madness received a $2m investment from the 5 investors listed (i.e. 500 start ups, etc.) and not 5 separate investments of $2m. Is there a way to consolidate the data like I have in the desired outcome section? So if in the instance a Date,Company,Size match in the data then it will consolidate the two events into one row because it's actually one event.