Listing only non zero amounts

Welcome to the forum!

If I'm understanding you correctly, the following formula, array entered (confirmed with Ctrl+Shift+Enter instead of Enter) in G1 and filled down should do the trick:

=IF(LARGE(($B$2:$E$5>0)*($A$2:$A$5=$F$1)*($B$2:$E$5),ROW(1:1))>0,LARGE(($B$2:$E$5>0)*($A$2:$A$5=$F$1)*($B$2:$E$5),ROW(1:1)),"")

Check out the attachment to see if I've got the arrangement correct:

That's it. Thank you so much.