Hi,

My original data is as follows. The first 2 letters in each columns are variable name and year
country RQ2017 RL2017 CC2017 RQ2016 RL2016 CC2016 RQ2015 RL2015 CC2015 RQ2014 RL2014 CC2014
1 0.64 0.42 0.42 0.64 0.42 0.42 0.55 0.42 0.42 0.55 0.42 0.42
2 0.50 0.50 0.33 0.55 0.50 0.33 0.68 0.50 0.33 0.68 0.50 0.33
3 0.45 0.42 0.17 0.50 0.42 0.17 0.50 0.42 0.17 0.59 0.42 0.17
I would like to convert to
country year RQ RL CC
1 2017 0.64 0.42 0.42
1 2016 0.64 0.42 0.42
1 2015 0.55 0.42 0.42
1 2014 0.55 0.42 0.42
2 2017 0.50 0.50 0.33
2 2016 0.55 0.50 0.33
2 2015 0.68 0.50 0.33
2 2014 0.68 0.50 0.33
3 2017 0.45 0.42 0.17
3 2016 0.50 0.42 0.17
3 2015 0.50 0.42 0.17
3 2014 0.59 0.42 0.17
I used the reshape function, however, it did not allow me to convert directly to what I expect. Any suggestion is greatly appreciated.

Thank you so much