I am attempting to sort information on building energy use and building
systems employed, where some buildings use multiple systems i would like to
lock those rows together so that when filtered they will remain together.

ie. use an autofilter to keep all the buildings which use chilled beams,
these buildings' groups of cells remain visable therefore all information and
systems for them are still on screen.

I understand this could be done in a large matrix using one column for each
system and indicating by binary which have what, however it would be far more
effective to be able to list the systems and seach the grouped lists.