We have projects in various states. Some of the states that we conduct business in have special building code requirements...
I have a spreadsheet of the projects and a column listing which state they are in, for example TX.

I'd like to list on a separate sheet, the codes required by that state. In each row, a separate code requirement. For example, on sheet-2 column-A, the codes for TX in rows 1-10; Column-B, the codes for HI in rows 1-10; Etc.

Back on sheet-1, I'd like a column set up for special codes.
If the "state" column lists TX, then the "special codes" column would list all of the corresponding codes for that state.

Thanks in advance for your help.
Mike