Remove duplicates help

[erisaaka]

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.

[Mazzaropi]

Erisaaka, Good afternoon.

Please, attach a Excel file, instead a PICTURE, to easier the answer to your doubt.

I believe that the answer will come soon.

[erisaaka]

How do I attach a file? I don't see that option....

[Mazzaropi]

Erisaaka, Good afternoon.

To attach files you need to click de "Go Advanced" button at the end of page.

BUT this time I believe I did what you want.

Take a look at the example attached and tell us if it worked for you.

After you finish your task you can simply copy and special paste just value at NEW REPORT TAB to have a functional and no indexed tab.

I hope sincerely it helps you.

Greetings from Brazil.