Sum, Merge, And Delete Duplicate Rows---PLEASE HELP!

[kodhanrajesh]

Here is the scenario please help me out

Input data in excel spreadsheet
Year Month Account Entity Class Class Scenario Amount
2011 Jun DAC Aviva Personal GI QF1 10.24
2011 Jun DAC Aviva Personal GI QF1 10.26
2011 Jan DAC Aviva Personal GI QF1 6206.381124
2011 Mar DAC Aviva Prof GI QF1 1138.281148
2011 Apr DAC Aviva Personal GI QF2 9683.894766

Output/expected data in excel spreadsheet
Year Month Account Entity Class Class Scenario Amount
2011 Jun DAC Aviva Personal GI QF1 20.50
2011 Jan DAC Aviva Personal GI QF1 6206.381124
2011 Mar DAC Aviva Prof GI QF1 1138.281148
2011 Apr DAC Aviva Personal GI QF2 9683.894766

 

[Derek Brown]

Hello and welcome to The Board.
My first thought would be to use the data to produce a pivot table.
Would that work for you?