How to sum duplicate values then remove the duplicate rows?

Hi everyone. Hoping someone might be able help me. I have huge amount of data like this.

Account Code------ Date------ Journal No.------ Transaction #------ Debit------ Credit
6052------ 17-Feb-12------ 6405------ 11592128 ------------------ 339------------ 5
6052------ 24-Feb-12------ 6426------ 11592146------------------ 564------------
6052------ 24-Feb-12------ 6426------ 11592146 ------------------ 564------------
6052------ 24-Feb-12------ 6426------ 11592146 ------------------ 544------------
6052------ 24-Feb-12------ 6426------ 11592146------------------ 544------------
6052------ 24-Feb-12------ 6428------ 11592143 ------------------ 544------------ 5

Now, I need to add up all the values under debit and credit columns that have the same transaction number/date and journal No. and remove all the extra rows like this

Account Code------ Date------ Journal No.------ Transaction #------ Debit------ Credit
6052------ 17-Feb-12------ 6405------ 11592128------------------ 339------------ 5
6052 ------ 24-Feb-12------ 6426------ 11592146 ------------------ 2216------------
6052 ------ 24-Feb-12 ------ 6428 ------ 11592143------------------ 544------------ 5

Is there any way to do this other than manually as it would take ages?

Thanks a lot in advance

P.S I know I have made a mess with this table, but I hope you get the point

Hi,

Would you upload the workbook and manually add the results you expect. We don't need zillions of rows, just enough to see the pattern. Clearly explain in a note how you have arrived at the results. It's not at all clear to me what you mean by 'extra rows' and how you define them.

Would a Pivot Table not be a neater and more elegant and flexible solution. See attached

Hi,

I don't understand what you mean. The Pivot Table gives exactly the same results as those you specified in Sheet1. If you want something different then create an example and upload the workbook again.

Hi,

Select the Transaction Date in the Field List, Choose Field Settings, Layout & Print and tick 'Repeat Item Labels.

Happy to have assisted and thanks for the rep.

Was it Management that were insisting on repeated row labels? Personally I think it looks neater (and certainly less cluttered) if stuff isn't repeated where it's not necessary. But of course we all have different views on what looks 'best'