Hello,
I would to transpose several columns in two news columns
I have a dataset like this one
Station Sp1 Sp2 Sp3...Spn
1
2 (numeric data)
3
And I would like to transpose the species and their values in two news columns and keep the station column
Station Species Values
1 Sp1 (numeric data)
2 Sp1 (numeric data)
2 Sp2 (numeric data)
2 Sp3 (numeric data)
3 Sp1 (numeric data)
3 Sp3 (numeric data)
Thanks