|Sounds like you could transpose the data to columns insteaed of rows (sould use transpose feature to do this). |
Title A1 with "Company" and B1 with "Credit Rating" where company1 is in A2 and the credit rating start in B2.
Company Credit Rating
Then use the data filter to filter all of column A and B.
Selecting the dropdown on column B's filter, select the text filter and enter criteria where column B contains BBB.
Should return you Companies 1, 3 and 4