to summarize a table

hello all

I have a table ,created in memory as below:

how to sumarize this table ,so it merge (sum) the value in column where ever the year and the month are same.
Here I show the table after summarized also

//----------------------before

           year      Month      Val1             Val2             val3          Val4

           2009     11            900000       0                  0               0
           2009     11            0                 700000        0               0
           2010     3              6100000     0                  0               0
           2010     3              0                 7500000      0               0
           2010     3              0                 0                  900000     0
           2010     3              0                 0                  0               0

//------------------------after

           year      Month      Val1             Val2             val3          Val4

           2009     11            900000       700000        0               0
           2010     3              6100000     7500000      900000     0

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
Accepted answer
You did not specify what class you are using in memory for the data, so I assume you don't want specific information. I also assume the data is sorted in the manner you show.

Just iterate through the data and when the next year and month are the same as the previous, summarize; when they are not the same, set the summaries to the current values.