Identify data ranges and remove any superfluous ranges

I have a spreadsheet populated from a database, the output format of which I cannot alter, as shown attached.

I need to identify ranges, based on a name for example, and get rid of everything else.

In the attached example it can be seen that i have ranges based on colour names, blue, red, pink, etc. Each of these ranges contain columns containing data, labelled 1, 2, 3, etc. (i.e. Row 2 contains headings)

In this example I wish to select the ranges relating to black, i.e. black 1, 2 & 3 and remove all other columns.

Could anyone please assist.

Thanks,