I have a 3,000+ line worksheet with data about every member at our
country club. The member # is in Column A.

Each member # might have 20 rows of data that I want to keep in a
group.

Perhaps I am using the wrong term, however....

First I imported the raw data, then I sorted by member # (Column A)

Then, I needed sub-totals for the rounds of golf and the revenue, so:

For every change in member # in Column A, I subtotaled other columns.

That is the beauty of the sub-total feature.

Now, I want to sort by the member with the most rounds of golf,
however, I want all of the data of the member kept together.

How can I group the rows with the same member #?

Perhaps I am using the wrong term as "group."

Thank you in advance for any help you can give me.