Google spreadsheet “=QUERY” join() equivalent function?
Short answer Google QUERY Language version 0.7 (2016) doesn’t include a JOIN (LEFT JOIN) operator but this could be achieved by using an array formula which result could be used as input for the QUERY function or for other uses. Explanation Array formulas and the array handling features of Google Sheets make possible to make … Read more