Google spread sheets, query, combine concate columns

Question

I did a search and it seems I can't use concate in the query SQL string.

How can I combine two columns that have only strings in each row:

C = Firstname
D = Lastname
Combine = Firstname Lastname

=query(RAW!1:1000;" SELECT * ,concate(C,D) WHERE B='"&C2&"' ";-2)

score 0 · Answer 1 · answered Oct 05 '17 at 15:24

0

 =ARRAYFORMULA(C:C&" "& D:D)

answered Oct 05 '17 at 15:24

TheMaster

@F T I'm not getting you. Share your sheet. – TheMaster Oct 06 '17 at 11:48
[link](https://docs.google.com/spreadsheets/d/1Bvtcm1MZ1Hy6F0QWoYrOYmaBqIWYEvw2KaGj6dCbxFE/edit?usp=sharing) @anonymous – F T Oct 09 '17 at 07:49
@F T `=ARRAYFORMULA(query({RAW!A1:C5\RAW!D1:D5&RAW!E1:E5};" SELECT * WHERE Col2='"&C2&"' "))` – TheMaster Oct 09 '17 at 10:06

1 Answers1