Creating lists with multiple criteria

Hello all, thank you so much in advance for your help with this problem. I'm sure it's been answered before but I can't find it.

I have a list of names and banks with corresponding balances. If the balance breaks a certain threshold I'd like the name, bank, and balance to show up on a report automatically.

If there were only 1 bank per name, I have ideas how to make this work. But having multiple banks per name is what's tripping me up.

Could you please see the attached sample? It shows the lists in one tab and the output I'm looking for in a second tab.

Again thank you so much in advance.

Steven

Just picking up on the suggested solution: Maybe the HSTACK part:

Please Login or Register  to view this content.

is unpivoted a little bit nicer in the following way:

Please Login or Register  to view this content.

If you're opted in the Beta channel and have already access to the relatively new group function, then the same result can be achieved relatively easily via:

Please Login or Register  to view this content.

Thank you both for your help. I would never have figured that out. I'll mark this as solved now.