Transform country-by-country data

[Jack Brue]

Dear Community,

Could you please help me to transform country-by-country data from this format

to this format

Thank you!

[William Lisowski]

You will need to use the reshape long command.

For more concrete advice, start by creating a Stata dataset containing the data as it now exists and then use the dataex command to recreate the example you posted in a form usable for demonstrating Stata coding.