Return multiple looked up text values?

Hello,

Appreciate if someone could help me to create a formula so that multiple and unique text values are returned in a transpose/horizontal format for 1 looked up value in Sheet 1.

See an example spreadsheet attached.

Sheet 1 - "Types" text values in column B that are supposed to be looked up in Sheet 2 and return multiple Disciplines from Sheet 2 to Sheet 1 in rows in front of each looked up value.

As I understand I need to use Index and Match functions? Unfortunately, having read a few excel-related articles on the internet I still can't figure it out.

Thanks in advance

Examp.xlsx

try in C3 sheet1:
=INDEX('Sheet 2'!$B$2:$B$15575,MATCH('Sheet 1'!$B3,'Sheet 2'!$A$2:$A$15575,0))
and copy down

Thanks a lot for help to everyone.

Glen, nflsales, looks like your formulas return different amount of values. Glen's solution returns more unique values. Formulas are slightly different. Glen, I respect your advice regarding deleting blanks and some sorting first however, I would prefer to have a formula for an original layout because this is a dump from different system and for ease of future use I would prefer formula to work with an original dump.
May I ask you to kindly update your formula so it works with the original dump without "Combo" column?

nflsales, perfect! exactly what I need! Thank you!
Thanks to everyone once again for prompt assistance!