I hope this is the right forum. I have some spreadsheets with about 50k+ rows and approximately 8 columns. The Columns contain the normal data (for example "Company name, expenditures, location etc). I did google this first, but I'm not thinking of the correct search terms, because my search is not returning what I'm trying to do here. What I'd like to do is group unique rows by features of each company. For instance, ABC Wrecking in Los Angeles and all of the expenditures for that location as its unique identifier, then ABC Wrecking in Las Vegas and its expenditures and so on. I know you can do that with filtering, but I'm hoping to go a step further and that there's some way to combine all rows into one, and add all expenditures together, so that out of 5 entries for each company, I end up with one row and a total expenditures for all previous entries for that company.

I hope that makes sense.

Thanks in advance!