Hello! I have to make a chart with all items by a specific vendor. My manager would like a chart that can be sorted, but would also like different variations of the items.

what I have for my headers

Item Number, Item, BOH, Cost, Total, Category

example

23729, 15 PC Bath set, 0, $5.50, $0.00, Bathroom
43392, 3 PC Bath Set, 0, $5.50, $0.00, Bathroom
53943, Carmella 5x8, -4, $52.00, -$208.00, Rug
53944, Dier Debwan 5x8, 7, $40.00, $280.00, Rug

Now I have made a chart from that and so all the columns can be sorted, my issue is now I have sheets and different colors of sheets.

Example

12345, Queen Sheet Set, 0, $5.50, $0.00, Bedroom
White
black
blue
green
12346, King Sheet Set, 0, $5.50, $0.00, Bedroom
White
black
purple
orange

My Manager wants the colors separated as you can see above. But each color would be its own row. Is it possible to lock the color rows to the parent, so when I sort the whole spread sheet the colors will stay below the sheet row to which they belong?