If I had to use Excel why would I text you?

The thing is as per design Total should be visible once and Debtor column should also be visible once.

Total for Debtor and then again Total is being displayed which is not right. Please Provide a valid solution. As I have many customers/vendors and I can't go to excel all the time. Please Help thank you. Just Remove the last Row. How to do that?