Filter 2D Array if row next to it is blank

[J-Des000]

Hi again,

I need to filter a column 2D array based on if there are values or not in the row next to it.

Sample file attached.

Thanks in advance.

[#2 · Accepted solution]

@J-Des000 

If you have Microsoft 365:

=FILTER(B9:B13, BYROW(C9:F13, LAMBDA(r, COUNTA(r)<>0)), "")