This is the type of data I have. The actual spreadsheet is 15 columns
by 100 rows.

A B C D E

Task 1 x x x
Task 2 x x x x
Task 3 x x x
Task 4 x x x
Task 5 x x x x

I want to be able to identify which rows are the same, and to be able
filter the final list by either row group or column (to be able to see,
for example, only rows that are part of a particular group, or only
rows that have check marks in specific columns).

In the example, I would identify rows 1 and 4 as a group, rows 2 and 5
as a group, and row 3 as a group.

In the actual spreadsheet, I have been able to identify the row groups
by repeatedly filtering the list, and then identifying in column F
which rows are in a group. This allows me to filter column F by group.

This mechanical process is time consuming. Is there a faster, easier
way?