Use Auto-Filter to show only the rows that have a "1" then copy the visible rows.

Optional:
Pivot Table using the column counting column as the Page Field and show only "1"

Or

Use Advanced Filter with criteria to extract the records where the value is equal to "1".