I'm looking to create a script to convert a matrix of species abundance e.g:
into two vectors e.g:
If you feel there is no easy answer to this and that it would be easier to do in excel or open office calc (or another program), please let me know.
Questions on Cross Validated are expected to relate to statistics within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
How about something like this:
I think this question is OK in the stats section of stack exchange. I've noticed that this is a really common data transform for people in Biology to prepare their data for statistical analysis.