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