Loop to scan data and aggregate Rows that are the same

Hi guys,


What I am trying to do is get excel to aggregate lines where the information is part of the same transaction [more info coming]. Right now it appears broken up in pieces, so there are may be 3 or 4 or more rows for a particular transaction, each with different "Profit" in column O and "Amount" in column D and the rest of the columns data being the same.

Ex:
Account “a12” bought “Harry Potter and the Philosophers Stone” 4 times each different "Profit" in column O and in different "Amounts" in column C. However info from A:C, E:N is identical signaling it is the same transaction.

Goal
I want excel to Loop through my spreadsheet and if it finds rows where a transaction is split, aggregate the data summing Column D and O, the other columns will simply be a simple copy paste as they all use the same data, the end result would be 1 line of data aggregating it

I really appreciate your time looking at this, please help me... have a good day!

Surely a Pivot Table is the Optimum and more elegant solution - see attached.
Never resort to VBA when there are perfectly straightforward Excel Functions or functionality.

I'm assuming the account A12 10 times was a typo. There are only 4 lines