Pivot Table/Removal of Total Lines

Hi,

I am struggling a bit with the attached file. Is there a simple way to remove the "Total" row for each customer?
I would like to use this data in a pivot table eventually which I know how to do. Not sure if there is a simple way to remove these rows all at once. Thanks!