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$) | ... | ... | ... | ... | ... |
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!
0 Response to How to get rows into columns when non transposable?
Post a Comment