How can I change quarterly data into yearly?

[martynaxx99]

Hi guys, I researched some data for my project, and the problem is that it's shown as quarterly, so instead of having 2005, 2006, 2007 etc. I have Jan-March 2005, April - June 2005, July - Sep 2005 etc. What's the formula to change it? I tried everything, I'm really bad with excel anyway so I'm struggling I'll post a picture so you can see what I mean!

Link to the image: https://imgur.com/a/55VmW

 

[anglais428]

Just insert a new column "2005" and then add together the 4 quarterly periods of data to get the annual data.

 

[steve the fish]

You could calculate 2005 and row 11 like this:

=SUMPRODUCT(--(ISNUMBER(SEARCH("2005",$B$4:$O$4))),B11:O11)

Replace "2005" with a cell reference that contains 2005 if you want. Drag down and you will get row 12 etc.