google-query-language

218 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Join multiple columns horizontally into one column with ArrayFormula
user_114622740
•
1
1
74
google-query-language google-sheets-formula flatten transpose google-sheets
Google spreadsheet Query function parse error on 1 column
user_192834600
•
1
1
64
single-quotes google-query-language google-sheets syntax arrays
Transform a data table from column based data to list column headers by their unique table entries
user_132931900
•
1
1
31
google-query-language data-transform flatten google-sheets pivot-table
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 1, column 47
user_193136420
•
1
1
206
google-query-language google-sheets-formula if-statement syntax arrays
Make a list of incremented numbers from a set of numbers
user_117751290
•
2
1
50
google-query-language google-sheets sequence sum arrays
Conditionally Sum a googlesheet column based on entries in related tables
user_71012900
•
1
1
44
google-query-language google-sheets-formula google-sheets sum arrays
VLOOKUP: How do I match one column to another sheet and join them without losing data?
user_157287170
•
1
1
34
vlookup google-query-language google-sheets-formula if-statement filter
Expandable Importrange
user_152505940
•
1
1
29
textjoin google-query-language google-sheets-formula google-sheets arrays
Google Sheet: Fetch earliest date and average of value of month from the list
user_191972420
•
1
2
43
google-query-language google-sheets-formula google-sheets number-formatting average
Converting a 2D range into a 1D array with spaces in Google Sheets
user_191993320
•
3
4
77
google-query-language flatten google-sheets filter arrays
Hot Questions