Re-arrange data table

CrackedEgg Posts 1 Registration date Thursday September 24, 2015 Status Member Last seen September 24, 2015 - Sep 24, 2015 at 04:21 PM
I am looking to re-arrange several tables. They are all in this type of format.

Each table does not have a set number of rows and columns. Also each species will only occur once per plot. I need them in a format as such...

I found this link which is the exact opposite of how I need to modify the data.

Thank you so much!