Combine rows and total three colums

I have a large amount of invoicing data (10000 rows) that I would like to summarise.
I would like to sort by 'Inv No" Column "A" keeping the data in the first 7 columns and total the data in the last 3 columns
I have attached sample data and a sample expected outcome.
I was hoping for some code that I could run to do this as I will have an ongoing need for it.
Your assistance is much apreciated.