Stack Overflow
Stack Overflow

Questions tagged [google-sheets-query]

Use for question about the QUERY function of Google Sheets.

Use this tag for questions about the QUERY function of Google Sheets.

QUERY is a non-standard spreadsheet function. It uses Google Query Language

It could be used together with

Usually it will not be used with

1444 questions
3
votes
1 answer

Google Sheets import range returning incorrect data

The full google spread sheet system is used for score keeping and is prone to delays when updating, however I have never run into an issue like this were the same basic function is returning two separate results. The problem is repeatable and occurs…
FootballGuy
  • 33
  • 3
3
votes
1 answer

Google Sheets function to group and concat rows

Sample sheet: https://docs.google.com/spreadsheets/d/1AeP0sxDi0-3aaesUdCNTKfricIimjTMFaKO-FX9_g50/edit?usp=sharing I am trying to find a formula that will group a table on a column and concat the values from all the rows in another column. For…
IMTheNachoMan
  • 5,343
  • 5
  • 40
  • 89
3
votes
1 answer

Skipping a value insertion on Google Sheets PHP

$valueRange = new Google_Service_Sheets_ValueRange(); // You need to specify the values you insert $valueRange->setValues(["values" => ["$now", "SKIP", "SKIP", "SKIP", "$quantity", "SKIP", "SKIP"]]); // Add two values // Then you need to add some…
Jk135
  • 31
  • 2
3
votes
2 answers

Query function to get last row in Google Sheets

I have a sheet where data is updated daily. however, the last integer often ends in between row 131 to 133. how do I run a query function to display the last integer in row 1 column C? I cannot do a simple =A131 on C1 because it can be on A133 the…
sheetsquestions
  • 67
  • 1
  • 4
3
votes
2 answers

Merge all cells to one cell and separate with comma

I use Google Sheets, and I want to get data and create one new cell. Example: I have 300 rows and 4 columns, like: 1|3|2|4 5|7|6|8 9|11|10|12 ... 297|299|298|300 and one cell that I need in…
user10426840
3
votes
2 answers

How to filter by date in Google Sheets?

I have a basic table with simple data. I need to filter data by date, for example, I want to see only items with dates between 03/03/2016 and 03/04/2016. This query looks like this: select A, B WHERE A >= 42432 AND A <= 42463 If I change date in…
rinatoptimus
  • 427
  • 1
  • 5
  • 21
3
votes
1 answer

Combining similar part of a string using Google Sheets functions

Please help me solve this problem. I'm trying to search all similar part of a string combine them then add all their numeric value at the beginning part of the string. Input: cell A1 2 x Onsemi 3000K E27; 7 x Onsemi 3000K E27; 9 x Phoenix Eco 7W…
Enrico Mendiola
  • 131
  • 1
  • 7
3
votes
1 answer

How do I select rows, order by date desc in Google Sheets?

I have column A as ID , column B as Score and column C as Date in Google Sheet and I wanted to select the data and ORDER by column C DESC. The result come out as below: A B C 123 100 30/07/19 111 100 30/07/19 113 100 29/07/19 112 100…
aWeakProgrammer
  • 69
  • 2
  • 8
3
votes
1 answer

How to combine rows with same ID in Google Sheets?

I'm trying to merge rows with same IDs in Google Sheets From: ID | Category Augur | A1 Augur | A2 Augur | A3 Augur1 | A1 Augur1 | A2 Augur1 | A3 To: ID | Category Augur | A1; A2; A3 Augur1 | A1; A2; A3 Is there an automatic way to do…
kristoff
  • 93
  • 9
3
votes
2 answers

Google Sheets Sumifs with date condition

I'm getting an error when trying to grab the money I have spent for a month on another Google Sheet using SUMIFS formula. I'm new to writing formulas and this is the first bottleneck I haven't been able to find. I'm trying to write a formula in my…
ottmduncan
  • 41
  • 1
  • 2
3
votes
2 answers

Google Sheets regexextract first letter of each word

how do I display the first letter of each word in let's say cell A1: Example: A1= Foo bar A1= Foo in the first example, I want to display "Fb" in the second example, I want to see "F" If A1 = empty I don't want to show anything I tried…
Ralph Schipper
  • 701
  • 2
  • 12
  • 24
3
votes
2 answers

Normalize Data in Google Sheets - TRANSPOSE multiple columns Fill Down

I have data I need normalized. Any value in Col C separated by a comma needs its own row. Here is my sheet The Data is in Col A - Col C and the Desired Result is int Col E-ColG. This question was helpful and I got the formula working for col C but…
moonshot
  • 649
  • 1
  • 5
  • 13
3
votes
1 answer

Adding sheet name as column to query in Google Sheets

I have a Google Sheets document with my video game collection. Each console system has its own sheet, but I decided to consolidate all sheets into one new sheet as an overview using a query that looks something like…
Roaziel
  • 63
  • 1
  • 7
3
votes
1 answer

How can I escape double and single quotes in google sheets query?

I have this query in google sheets cell: =QUERY(Sheet1!A2:F, "SELECT * WHERE A='te'xt"text'", 0) I can escape double quote like this: text""text But how can I escape double and single quote? te'xt"text
Дмитрий Миронов
  • 79
  • 1
  • 4
3
votes
2 answers

Adding blank rows in a set of data in Google Sheets

I have a set of data. What i am looking forwards is to add 2 blank rows after each set of 3 values like this Hope to get help in getting this solved. you can find the sample google sheet here :…
Shijilal
  • 2,175
  • 10
  • 32
  • 55
1 2 3
…
96 97