available|Ben Collins|Data Cleaning and Pivot Tables in Google Sheets

If you start with “bad” data — if your data contains duplicate records for example — you’re inevitably going to end up with “bad” conclusions. You might end up double counting revenue, for example, which could have disastrous consequences for your business down the line.