Re-arrange data table

Closed
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.
https://ccm.net/faq/5335-excel-re-arrange-data-from-columns-into-rows

Thank you so much!