Hi,

UGENT HELP PLEASE

I need to reshape my data from wide too long in order to merge it with already existing merged panel data. I have created a new variable, country, with a list of 38 countries. These countries have data on natural resources rents from years 1990 t0 2017. I need to make all these values into 1 column. Therefore creating a new variable, year. I have performed the command below but no luck;

Array

The letters B, C, D...are the variables representing the years 1990, 1991, 1992 ....which I am trying to merge into one column year.
I will also need to create a variable, nat, that will consists of the values of the total rents in all the years for each country in one column.


Thank you