Hi all, I have a data set of average species covers in 19 different sites. However when grouping and summarising, I have ended up with multiple rows for the same site and NA's in between, see photo below.
Is there a way I can combine the rows so each site only has one row, with each column containing a value for species cover? I understand that there will still be NA's, as not every species was found at every site, but collapsing rows into one per site, and then changing NA's to 0's after will allow me to perform NMDS ordination.
Thanks so much!