[R] Presence/ absence data from matrix to single column

[agoijman]

I've been trying to reshape this database but haven't succeed at it. I tried
using loops but can't get it right. I just want to reshape my database from
this matrix, to the one below, with only one column of data. 

Year	Route	Point	Sp1	Sp2	Sp3
2004	123	123-1	0	1	0
2004	123	123-2	0	1	1
2004	123	123-10	1	1	0

What I want:

Year	Route	Point			
2004	123	123-1	Sp1	0	
2004	123	123-2	Sp1	0	
2004	123	123-10	Sp1	1	
2004	123	123-1	Sp2	1	
2004	123	123-2	Sp2	1	
2004	123	123-10	Sp2	1	
2004	123	123-1	Sp3	0	
2004	123	123-2	Sp3	1	
2004	123	123-10	Sp3	0	




--
View this message in context: http://r.789695.n4.nabble.com/Presence-absence-data-from-matrix-to-single-column-tp4645271.html
Sent from the R help mailing list archive at Nabble.com.