Transpose columns to a news columns


I would to transpose several columns in two news columns
I have a dataset like this one

Station   Sp1 Sp2 Sp3...Spn
2             (numeric data)

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)


This is one way:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.