I want to group each state in a group. Grouping Florida works fine, but when I select the rows with New Jersey and select group, it groups Florida and NJ together. The only way I can figure out how to do this is to put a space between the states to force a break. Is there a way of grouping contiguous rows in different groups?

Attached Images

Capture.JPG (93.3 KB, 20 views)

As an image is useless, please post a sample sheet - Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Attached is the WS.

Attached Files

Book1.xlsx (12.4 KB, 11 views)

I can't seem to reproduce the problem. So you click on the arrow next to "state" - Menu opens - Uncheck Select All and check "New Jersey" - Right?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Not quite. I know how to filter using the dropdown arrow. My question is regarding the grouping. This is the function in the Outline group in the Data tab.I would like to make 4 groups that I can collapse and expand. One for each state. For example, select the rows containing Florida and select Group in the Outline group of the Data field. Now if you want to group NJ as another group, Excel combines Florida and NJ into one group. Now, instead of NJ you select Oregon, you'll get two groupings.