I need to take separate columns containing first and last names on one spreadsheet, and combine them into a single column on a different sheet. Right now my formula is
=CONCATENATE(IMPORTRANGE("URL", "A1:A3"), " ", IMPORTRANGE("URL", "B1:B3"))
What I would want is to get a single column of
First1 Last1 First2 Last2 First3 Last3
But instead I am getting
Because the second argument in the
IMPORTRANGE function is a string, I can't just direct it to one cell and then drag the function over multiple cells like I normally would when concatenating. Is there a way to accomplish what I want without copying multiple data sets into one spreadsheet and working from there?