Lookup creteria match formula with results in rows (horizontal)

Try this
Enter in E3, copy across and down
Array formula must be entered with Ctrl+Shift+Enter key combination.

Formula:

=IFERROR(INDEX($B$3:$B$18,MATCH(0,IF($A$3:$A$18=$D3,COUNTIF($D$3:D3,$B$3:$B$18)),0)),"")

v	A	B	C	D	E	F	G	H
1
2
3	MX	Beatle		MX	Beatle	Mites	Cobra
4	AA	Eel		AA	Eel	Spider
5	EK	Ant		EK	Ant
6	OP	Cobra		OP	Cobra
7	LD	Centipede		LD	Centipede	Crab	Hyte
8	AA	Spider		PP	Eel
9	LD	Beatle		BB	Sting
10	MX	Mites		CP	Crab
11	PP	Eel
12	BB	Sting
13	AA	Spider
14	CP	Crab
15	LD	Crab
16	BB	Ant
17	MX	Cobra
18	LD	Hyte
19