Dedupe and paste row?

[Barny]

Hello All,

I've been having some issues with a log I use at work and am seeking a bit of guidance.

Below is a sample of the log

\1

What I’m after is either a formulae or VBA/macro that will look at the account numbers and remove any duplicates. However if there is an entry in the number of returns column(s) then cut the data from the duplicate row and paste it into the original/unique.
Merge might be the word to sum this up better. Is it possible to merge the account numbers that apper more than once taking the number of returns cells with them?

Is this possible or asking too much?

Hope this makes sense!

Thanks,
Chris