I have a google sheet that I would like to be able to filter only certain cells of a column instead of the whole column or a range. For example, I would like to be able to alphabetically filter “Property Names” in column D. But the property names are only in certain cells. Is there a way to make a filter with only specific cells not in a range? For example: Property Names are in cells D5, D16, D28, D40, etc…

Also, How do I keep grouped rows permanently together? This is another problem I have encountered. When I use a filter or sort, that it jumbles all the grouped cells. For example: rows 5-15 are grouped but when I filter the rows do not stay together. Google Sheet

I tried to use grouping and protected range