Hi all ,

I was wondering whether someone could help me with a command so I can convert my data into the desired format.
Current data (subset):
Countrycode Seriesname yr1996 yr1997 yr1998 yr1999 yr2000
BEL GDP (constant 2015 US$) a b c d e
BEL GDP per capita (constant 2015 US$) ... ... ... ... ...
BEL Population ... ... ... ... ...
FRA GDP (constant 2015 US$) ... ... ... ... ...
FRA GDP per capita (constant 2015 US$) ... ... ... ... ...
I want to convert this into a format where I have the variable "countrycode" "Population, total" "GDP (constant 2015 US$)" "GDP per capita (constant 2015 US$" and "Year".
With Year from 1996-2000 corresponding to the right value of population, gdp and gdp per capita.

So like this:
Countrycode GDP (constant 2015 US$) GDP per capita (constant 2015 US$ Population, total Year
BEL a 1996
BEL b 1997
BEL c 1998
BEL d 1999
BEL e 2000
FRA
FRA
FRA
FRA
FRA

I tried transposing it, but it didn't work because it's not a transposable matrix (doesn't have dimension = n x n)

Someone who can help me?

Thanks!