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      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

	[[alternative HTML version deleted]]

