Converting Monthly Data to Yearly Data

[megapc]

Dear all,

I'm struggling with convert variance of inflation monthly data to yearly data.
My monthly data looks like:
country1 month1 month2 month3 ... month12
country2 month1 month2 month3 ... month12
country3 month1 month2 month3 ... month12
....

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]countryname[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]country1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]country2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want to convert it to yearly like this:
country1 year
country1 year
country1 year
...
country2 year
country2 year
country2 year
...

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]countryname[/TD]
[TD]year[/TD]
[TD]value[/TD]
[/TR]
[TR]
[TD]country1[/TD]
[TD]1988[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]country1[/TD]
[TD]1989[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]country1[/TD]
[TD]1990[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]country2[/TD]
[TD]1988[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]country2[/TD]
[TD]1989[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]country2[/TD]
[TD]1990[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Below is the link to my data excel.

https://drive.google.com/open?id=0B3WI932UdUvCRU9VLWk0QVhoSm8

Best

 

[mole999]

could you not just add SUM at the end of you columns to return both month and year values in the same table ?