I have a master spreadsheet that contains columns like so:
FirstName LastName Gender etc, etc, etc
I need to import from that master sheet into another sheet that filters by one of the other columns. In the new sheet, I need name to be a single column, joining
Here is the current query I am using:
=query(importrange($SPREADSHEET_KEY, "Full Overview!A2:AH"), "select Col1, Col2, Col5 where Col8 contains 'Migrators'", 0)
I need to merge Col1 and Col2 from the master sheet into Col1 of the new sheet and put Col5 in Col2 of the new sheet.