Return next not blank result based on a raw

Question

I have the following sheet using G-sheets:

I have the following formula in H2

=ArrayFormula(IF(E2:E="", F2:F, IF(G2:G="", E2:E, G2:G)))

I want Col H to return non-empty text in columns E,F,G, but the formula does not return text from Col G. I wrote in Col I the result I want. Hope you guys can help

Answer 1

You may try this in Cell_H2:

=byrow(E2:G,lambda(Σ,if(counta(Σ)=0,,+torow(Σ,1))))