My computer really didn’t like dealing with this much data, but I started organizing it all into pivot tables and it seemed to work?
1. First I created a pivot table that summed all the rows labeled with the same protein name giving me one total number for each protein per site. I copied this data into a new sheet.
2. Then I summed each row and got protein totals across all the sites, which I then sorted by value from largest to smallest.
I put the file with my results in my folder on OWL:
Still working on figuring out how to upload the other documents.