Group based on cell content or color

Good morning all. I've searched for a little bit now, but can't find exactly what I'm looking to do. I also posted this question on another board, but received no help.

I am needing macro to Group Rows based on either cell content or cell/row color. A lot of the worksheets I work on usually have 5K+ rows and 100+ columns.

I have done Subtotals, but I don't think Subtotaling will work every time based on some of the data I work with. So, I am using a Pivot to format the data...but now need to Group the data to make it easier for the other users.

I need to Group by the Row Colors without the word Count. Make sense???

I have attached an example file.

Thanks for your time.