Remove duplicates help

I have an excel document that looks like this:
Capture.JPG

I need it to look like this:
Capture2.JPG

As you can see, the batch #, document #, amount, debit and credit all duplicate based on the number of debits that appear for each document #.

Any idea how I would do this?

I appreciate any help.