We’ll use an advanced filter on this data set. You already have the source data, so let’s add the criteria and location: Copy the header row to another sheet, twice, as shown in Figure B.

To copy only visible cells in Excel or Google Sheets, use the 'Visible cells only' feature, or apply filters to hide data. We show you how!

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.