VBA to Group Rows (outline) based on Text

Hello all,

First time posting! Just getting into the forum thing.

Anyway, I have a sheet that is generated via query and I'd like to add some VBA to group rows into their total lines using VBA.

Is there a way to loop through a table and group based on Text. In the attached, I would like to simply group the table based on column "B" so that I would only see "TYPE_ALL" when the report groups are collapsed. I am looking to GROUP, not HIDE the other rows.

I will also add that the table will expand and contract when the query is run so I would like to Clear the Outline and then create the Row Groupings each time.

Thanks in advance for your help!