Did you bother by removing values in a spreadsheet for your reporting? The hideOrRemove feature in SheetsRefiner addon make that easy by ONE click
Install the addon at https://workspace.google.com/marketplace/app/sheets_refiner/...
Install the addon at https://workspace.google.com/marketplace/app/sheets_refiner/...