Pivot tables help search your Google Sheets for duplicates. They are flexible and quick to use, so they are a…