Try this Array Formula. Since this is an Array Formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter.
In B11
=IFERROR(INDEX('Transfer Basic'!$B$1:$DE$1,SMALL(IF(INDEX('Transfer Basic'!$B$2:$DE$15,MATCH($D$4,'Transfer Basic'!$A$2:$A$15,0),)<>0,IF(INDEX('Transfer Basic'!$B$2:$DE$15,MATCH($D$4,'Transfer Basic'!$A$2:$A$15,0),)<>"",COLUMN('Transfer Basic'!$B$1:$DE$1)-COLUMN('Transfer Basic'!$B$1)+1)),ROWS(B$11:B11))),"")
and copy down.
In G11
=INDEX('Transfer Basic'!$B$2:$DE$15,MATCH($D$4,'Transfer Basic'!$A$2:$A$15,0),MATCH(B11,'Transfer Basic'!$B$1:$DE$1,0))
and copy down.
Bookmarks