Array formula to remove blanks (like autofilter)

Hey everyone,

I've been trying to figure out what I believe is a simple problem but I can't get it right. Attached is a sample spreadsheet that will hopefully illustrate my goal more clearly.

I have several customers that order various items. However, they do not all order the same things nor do they all receive the same prices due to volume, etc. So what I'm trying to do is that when I select the customer in cell J3, that columns I and J fill with the non-blanks from the table in B4:E19. My assumption is that the items will have to be referenced from the costs but I'm not totally sure about that since there would are non-unique prices.

This is essentially an auto-filter problem without using the built-in function but I swear I've had something like this set up before. Thanks for any help.

Try in I4:

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX($B$5:$B$19,SMALL(IF(INDEX($C$5:$E$19,0,MATCH($J$3,$C$4:$E$4,0))<>"",ROW($B$5:$B$19)-ROW($B$5)+1),ROWS($I$4:$I4)))))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down.

In J4:

=IF(I4="","",SUMIF($B$5:$B$19,I4,INDEX($C$5:$E$19,0,MATCH($J$3,$C$4:$E$4,0))))

confirmed with just ENTER and copied down.