Dear community,

I am trying to bring some data into a different format. The data is World Uncertainty Index, which is publicly available for research purposes (https://worlduncertaintyindex.com/). The data provided is in the format that doesn't fit my overall dataset with other variables, so I've been trying to reshape it but no luck.

Current data format is
Period AFG AGO ALB ARE
2009q1 var1 value var1 value var1 value var1 value
2009q2 var1 value var1 value var1 value var1 value
2009q3 var1 value var1 value var1 value var1 value
2009q4 var1 value var1 value var1 value var1 value
where three-letter codes are ISO-codes for countries.

What I am trying to get is as follows:
Country Period Var1
AFG 2009q1 value
AFG 2009q2 value
AFG 2009q3 value
AFG 2009q4 value
ARE 2009q1 value
ARE 2009q2 value
ARE 2009q3 value
Thank you in advance for any advice!


Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input str6 year byte(AFG AGO) double ALB byte ARE double ARG byte ARM double AUS
"1952q1" . .  . .   1 .         0
"1952q2" . .  . .   0 .         2
"1952q3" . .  . .   0 .         0
"1952q4" . .  . .   0 .         0
"1953q1" . .  . .   0 .         1
"1953q2" . .  . .   0 .         2
"1953q3" . .  . .   0 .         0
"1953q4" . .  . .   1 .         0
"1954q1" . .  . . 1.5 .         0
"1954q2" . .  . .   2 .         2
"1954q3" . .  . .   0 .         2
"1954q4" . .  . .   0 .         2
"1955q1" . .  . .   2 .         1
"1955q2" . .  . .   0 .         0
"1955q3" . .  . .   1 .         3
"1955q4" . .  . .   1 .         5
"1956q1" 0 .  0 .   0 .         0
"1956q2" 0 .  0 .   0 .         2
"1956q3" 0 .  0 .   1 .         2
"1956q4" 0 .  1 .   2 .         2
"1957q1" 0 . .5 .   0 .         0
"1957q2" 0 .  0 .   0 . .66666667
"1957q3" 0 .  0 .   0 . 1.3333333
"1957q4" 0 .  0 .   0 .         2
"1958q1" 1 .  0 .   0 .         1
"1958q2" 0 .  0 .   0 .         1
"1958q3" 0 .  0 .   1 .         3
"1958q4" 0 .  0 .   1 .         1
"1959q1" 0 .  0 .   0 .         0
"1959q2" 0 .  0 .   0 .         0
"1959q3" 0 .  0 .   0 .         0
"1959q4" 0 .  0 .   2 .         0
"1960q1" 0 .  0 .   0 .         1
"1960q2" 0 .  0 .   2 .         3
"1960q3" 0 .  0 .   2 .         0
"1960q4" 0 .  0 .   0 .         0
"1961q1" 0 .  0 .   0 .         0
"1961q2" 0 .  0 .   1 .         1
"1961q3" 0 .  0 .   0 .         2
"1961q4" 0 .  0 .  .5 .         1
"1962q1" 0 .  0 .   1 .         5
"1962q2" 0 .  0 .   0 .         4
"1962q3" 0 .  0 .   1 .         1
"1962q4" 0 .  0 .   1 .         0
"1963q1" 0 .  0 .   4 .         3
"1963q2" 0 .  0 .   3 .         0
"1963q3" 0 .  0 .   2 .         0
"1963q4" 1 .  0 .   0 .         0
"1964q1" 0 .  0 .   1 .         0
"1964q2" 0 .  0 .   0 .         0
"1964q3" 0 .  0 .   3 .         0
"1964q4" 1 .  0 .   3 .         2
"1965q1" 1 .  0 .   1 .         0
"1965q2" 0 .  0 .   1 .         2
"1965q3" 0 .  0 .   0 .         0
"1965q4" 0 .  0 .   0 .         0
"1966q1" 0 .  0 .   1 .         0
"1966q2" 2 .  0 .   2 .         0
"1966q3" 0 .  0 .   3 .         0
"1966q4" 0 .  0 .   1 .         0
"1967q1" 0 .  0 .   1 .         0
"1967q2" 0 .  0 .   0 .         1
"1967q3" 0 .  0 .   0 .         1
"1967q4" 0 .  0 .   0 .         0
"1968q1" 0 .  0 .   0 .         1
"1968q2" 0 .  0 .   1 .         1
"1968q3" 0 .  0 .   1 .         1
"1968q4" 0 .  0 .   0 .         1
"1969q1" 0 .  0 .   2 .         1
"1969q2" 0 .  0 .   0 .         3
"1969q3" 0 .  0 .   0 .         3
"1969q4" 0 .  0 .   0 .         0
"1970q1" 0 .  0 .   0 .         0
"1970q2" 1 .  0 .   0 .         1
"1970q3" 0 .  0 .   1 .         0
"1970q4" 0 .  0 .   5 .         2
"1971q1" 0 .  0 0   3 .         4
"1971q2" 0 .  0 0   2 .         0
"1971q3" 1 .  0 0   0 .         3
"1971q4" 0 .  0 0   1 .         3
"1972q1" 0 .  0 1   3 .         3
"1972q2" 0 .  0 0   3 .         0
"1972q3" 0 .  0 0   4 .         3
"1972q4" 0 .  0 0   1 .         0
"1973q1" 0 .  1 0   3 .         2
"1973q2" 0 .  0 0   2 .         8
"1973q3" 0 .  0 1   1 .         2
"1973q4" 0 .  0 0   3 .         1
"1974q1" 3 0  0 1   1 .         0
"1974q2" 0 0  0 0   1 .         0
"1974q3" 0 0  0 0   3 .         2
"1974q4" 0 1  0 0   3 .         3
"1975q1" 0 0  0 0   1 .         0
"1975q2" 0 0  0 0   2 .         2
"1975q3" 0 0  0 0   0 .         2
"1975q4" 0 0  0 0   1 .         1
"1976q1" 0 0  0 0   1 .         0
"1976q2" 0 0  0 0   2 .         2
"1976q3" 0 1  1 0   0 .         0
"1976q4" 0 2  0 0   1 .         2
end