Stack Overflow
Stack Overflow

Questions tagged [google-query-language]

Google Query Language is the part of the Google Visualization API that lets the developer perform various data manipulations with the query to the data source. This could also be used in the Google Sheets QUERY built-in function.

Google Query Language allow developers to perform various data manipulations using a syntax very similar to the SQL syntax. It's part of the and can be used in through the QUERY built-in function.

Before posting a question about the Google Query Language check the reference documentation.

1114 questions
2
votes
1 answer

Sort by date with IMPORTRANGE in Sheets

I am helping my son with a making a master spreadsheet using IMPORTRANGE formula in sheets. This is for keeping track of parts and orders. Then with multiple sheets being linked to the master, he needs to be able to sort all the data by the Due…
Sheila Russell Perry
  • 27
  • 5
2
votes
2 answers

Query sheet and return Column Headers that match two criteria in a row

I am trying to return an array of column headers based on TRUE values and Item names. Link to sheet <- Clicky Sheet 2: Sheet 1: (desired results) I think I am close but can't rack my brain to search for both TRUE values within the corresponding…
Kevin P.
  • 907
  • 7
  • 18
2
votes
2 answers

Filtering Values Produced by an ARRAYFORMULA

I am using an ARRAYFORMULA to extract unique values from a list of names and total up a second column for each of those names. Here is some example data and the ARRAYFORMULA I am using Example Data ARRAYFORMULA in cell…
FlereImsaho
  • 23
  • 1
  • 2
2
votes
1 answer

Is it possible to reference information that's currently only within a google sheet query?

I have a query (=QUERY(A9:N,"Select C,D,E,F,G,H,I where B contains """&L3&"""")) Which returns a header row and a row where the answers are either true or false - depending on the the tickboxes in the query array. I am trying to find whichever…
The_Lucky42
  • 23
  • 4
2
votes
1 answer

Transforming data from multiple columns to rows and keeping "labels"

I am trying to create a Google Sheet where some of the data is inputet on a column basis. Like this This input is done in a Input sheet. And then I want to transform the data into this form in the Output sheet. I have no idea how I could do this…
Siesta
  • 451
  • 7
  • 21
2
votes
3 answers

Formatting IMPORTXML Xpath query into readable data for Google Sheets

I am importing XML data to a google sheet which has the following structure: edit: URL: https://sonicstate.com/news/tools/revive_stats/client_camp_3785.xml 15802 Some name …
Nowski
  • 173
  • 1
  • 14
2
votes
1 answer

Repeat each row with empty rows n times - google sheets

I'm trying to repeat each row from the example column n times, very similar to this question (Repeat each row N times in Google Sheets) however, I am also looking to add n empty rows between each repeating element. Example…
Bam
  • 133
  • 1
  • 8
2
votes
1 answer

i am having issue using query function of google sheets

I am trying to query an XLSX file with the following statement =query($A$2:$E$34, "select E WHERE C = '1' AND A = 'Jun-21'"), in that case, C being a country number and A being the month and year and I am not able to get a value, I receive N/A…
CARLOSLEO280
  • 81
  • 4
2
votes
1 answer

How to collapse sheet by pivoting rows into csv data

I have a set of data where an account id can have multiple rows of country. I'm looking for an array function that will give me a unique list of accounts with the countries in the second column as csv values e.g. country1,country1,country3. If I…
Chris Rosendin
  • 305
  • 2
  • 14
2
votes
1 answer

Google Sheets: FIlter/Query/Other to Omit "0" values from Rows AND Columns

The business use case involves a work unit with about 11 people who produce a mixture of about 30 different widgets over the course of a month (Ex: August 2021). On August 1, 2021: Person 1 may be assigned to produce 20 widgets A's and 15 widget T's…
Brooke
  • 37
  • 3
2
votes
3 answers

Multiply each row using Arrayformula

In Google Sheets, I have the following data: | A | B | C | ... | G | TOTALS 1 | 100| 200| 400| ... | 870| =PRODUCT(A1:G1) | 2 | 120| 240| 360| ... | 232| =PRODUCT(A2:G2) | 3 | 125| 425| 100| ... | 509|…
Silva
  • 23
  • 5
2
votes
1 answer

Arranging data by occurrences

Given a range with multiple items, I would like to count their occurrences and present the result as shown in this Google Spreadsheet sample using just one formula, if possible. This is the closest that I…
zagalico
  • 35
  • 4
2
votes
2 answers

Is there an easy way to find multiple header columns given a set of data?

I have a sheet that looks like this: I'd like to have a formula that queries the data in A2:E7 and pulls the corresponding column headers from A1:E1. The trick is that values may appear more than once. Sample results would look like this: Example…
Falcon4ch
  • 152
  • 1
  • 1
  • 12
2
votes
2 answers

google sheet : How to find the length of array?

I try to query from other sheet using vlookup() or something similar. I want to count how many array it will produce. How can i find the length of the output or the resulting array from query() or filter() or vlookup()? Something similar to len()…
andio
  • 1,574
  • 9
  • 26
  • 45
2
votes
1 answer

How to evaluate a string in google spreadsheet

I wonder if this is possible in google sheet: cell A2 has string 100*2 + 50 How to get the result in another cell, such as A3 = evaluate(A2) and get 250? I have shared public google sheet "stringEvaluate"…
user15929966
1 2 3
…
74 75