I am clear that there is no concat method in google sheets queries but I'm hoping for a workaround. I've seen some suggestions for transpose but can't seem to apply them to my use, hoping for help.
My actual source sheet has more complexity in columns but I've simplified it to demonstrate
Existing Query
=query($L$10:$N$27, "SELECT L, M WHERE N = 'Full' LABEL L 'Name', M ''",1)
If Concat/Append were available it would look more like
=query($L$10:$N$27, "SELECT ("Name is: " & L & " " & M) WHERE N = 'Full' LABEL L 'Name'",1)
Thanks!
try:
=ARRAYFORMULA(QUERY({"Name is: "&L10:L27&" "&M10:M27, N10:N27},
"select Col1
where Col2 = 'Full'
label Col1 'Name'", 1))