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
>Solution :
You may try this in Cell_H2:
=byrow(E2:G,lambda(Σ,if(counta(Σ)=0,,+torow(Σ,1))))