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,
Bookmarks