Yesterday I was working on a spreadsheet that needed to SORT items from several different columns. SORT only accepts one argument, and I couldn’t find any examples online about how (or if) you could SORT multiple columns. Maybe this is obvious to everyone else, but it wasn’t to me.
The answer is to put arguments within an array like this one, which shows how to SORT columns from several different spreadsheets. You can even use a function within the array. Just enclose your list in curly braces separated by semicolons:
=SORT({UNIQUE('SpreadsheetA'!K3:K54); UNIQUE('
SpreadsheetB'!J3:J54); UNIQUE('SpreadsheetC'!P3:P54); UNIQUE('SpreadSheetA'!Q3:Q54)}) Here’s another example, which has multiple unnamed ranges from within a single spreadsheet:
=SORT({A1:A4; B3:B54; C1:C7}) 
