I'm trying to organise a large amount of data that needs to be analysed for my dissertation. The data in excel is about 32,000 rows with many repetitive rows that need to be summed together. There is a lot of other data in it as well which means a lot of the techniques I have tried haven't been working. Doing it all manually is pretty much impossible given my deadline so I was wondering if there are any ways to summarise that I'm not thinking of. I need to condense it based on site number and month. Each taxon_count also needs to be summarised for each order type. I have attached examples below. Thank you in advance!!
If you're looking at the excel file I need an efficient way of turning sheet 1 into sheet 2.
Bookmarks