Convert multiple series into single series

[willm]

Hi there,

I have a data set in which I have multiple series - all time series data from years 0 to 50. Essentially I'd like to combine them all into a single series

I want to convert the arrangement of data from this:

Year, Series_1, Series_2, Series_3
0, 3, 4, 7,
1, 9, 5, 8,

Year, Data, Series
0, 3, 1
0, 4, 2
0, 7, 3
1, 9, 1
1, 5, 2
1, 8, 3

I can't work out how to do it except manually, and I have 30+ series (and this is not the first time I've come across this problem)...

any ideas?