If I understand correctly then:
1. Populate a column (M in the attached file) using: =ISNUMBER(SEARCH(B$1,A101))
2. Populate the range that displays the information using: =IF(ROWS($A$2:$A2)>COUNTIFS($M$101:$M$139,TRUE),"",INDEX(B$101:B$139,AGGREGATE(15,6,(ROW($B$101:$B$139)-ROW($B$100))/($M$101:$M$139=TRUE),ROWS($A$2:$A2))))
Note that Conditional formatting is also applied to the range that displays the information. i.e. cells that contain zeros = white font
Let us know if you have any questions.
Bookmarks