I have a matrix with survey sites as rows and sponge species as columns. Cells have the sponge abundance for each site and species. I want to extract the 10 most abundant species for each site, with the corresponding abundance, and put these values into a new matrix.
I’m using a pivot table now, and it can list the overall top 10 species for all sites. I would like to extract the top 10 for each site, meaning each site would have a different top 10 list, and then collate all the rows together.
Right now, I can only get Top 10 for overall, instead of Top 10 of each site. How can I go about doing this?
Thanks in advance!