Hi Guys, what code can i use to convert quarterly data to Annual data; Here is a sample of the data. You will notice some quarters in some years are missing. But ideally i want to have annual figures summed up from quarterly figures per year per "Accper". I want to have totals for TOR and TOE in two new columns computed from adding up the different figures from the different quarters.