Newbe Dev Stack

Answer : This doesn't seem to work in Mac Excel 2016. After a bit of digging, it looks like the key combination for entering the array formula has changed from ⌘ + RETURN to CTRL + SHIFT + RETURN . Select the range, press CONTROL + U and then press ⌘ + RETURN .

Answer : You should be able to use a vertical array in the Spreadsheet 3 : ={IMPORTRANGE("Sheet1Key","SheetName!A2:A500");IMPORTRANGE("Sheet2Key","SheetName!A2:A500")} Of course, it is also possible to combine several IMPORTRANGE() functions with the QUERY() function , which gives us a greater control over the results we import . For example, we can use such a construction : =QUERY( { IMPORTRANGE("key-or-url-of-spreadsheet-1", "'sheet-name-1'!A2:Z100"); IMPORTRANGE("key-or-url-of-spreadsheet-2", "'sheet-name-2'!A2:Z100"); IMPORTRANGE("key-or-url-of-spreadsheet-3", "'sheet-name-3'!A2:Z100"); IMPORTRANGE("key-or-url-of-spreadsheet-4", "'sheet-name-4'!A2:Z100") }, "SELECT * WHERE Col1 IS NOT NULL ORDER BY Col3 ASC" ) Explanation: The above query removes blank lines from imported ranges : SE...