All Questions
Tagged with google-query-language flatten
110 questions
1
vote
1
answer
124
views
Error Query, and xlookup formula in dropdown list
Someone in this group had created a google sheet file for me. and I have given some names in the list in that google sheet files. Can you prepare the appropriate code to get the result through that ...
- 17
2
votes
2
answers
353
views
ARRAY_LITERAL error when Query Array Function stacking multiple google form responses [duplicate]
So I have a unique problem. I have a Google form used for site inspections that allows up to 25 "issues" to be entered per Form submission. As normal, when submitted the issues are recorded ...
- 97
2
votes
3
answers
95
views
Processing a list to output in a particular format
I am processing a list to output its items in chunks separated by blank rows as follows. But the result is not working when there are similar items, as shown with the arrows.
The formula I'm using is ...
- 334
-1
votes
1
answer
36
views
Google sheets get empty cells next to each other
Link: https://docs.google.com/spreadsheets/d/1hCG6jjGSGWMn5kBkDfcoTJkZ2eCC5SRvHWMFTBp_6OE/edit?usp=sharing
I want to return "Yes" or "No" results in column N when there are empty ...
- 25
1
vote
2
answers
45
views
Counting unique elements in a table
I have a table with names of players like this:
Player
John
Eric
Valerie
Carmen
And another table with a list of played matches (match number, match date and the list of players that played in the ...
- 455
1
vote
4
answers
731
views
how to concat/merge two columns with different length?
I'm new to google sheet. I have a column(E) with the date and another with a session(F), I want to merge them into one column with each date & different session just like the first few rows in ...
- 13
2
votes
3
answers
143
views
How to clear all commas except for commas in even position in sheet?
I have multiple rows of string where the string is all wrong. Here is one row an an example of the geometry and output expected:
id
geometry
output
1
POLYGON (( 106.812271, -6.361551, 106.812111, -6....
2
votes
1
answer
40
views
Filter the products where your calculated options generate a profit result
I need to filter for each of the products, which are the distances that are profitable using them.
In the example below, using car the profitable distance is 3 and skate the profitable distances are 3 ...
- 2,177
1
vote
1
answer
1k
views
How to write a google sheets query for summing by columns
I've got a sheet where I'd like to sum each column B-D but filtered/grouped by the value in Column A.
If I use a basic query like
=QUERY(B1:N100, "select sum(B) where A = 'whatever'")
then ...
- 5,705
0
votes
2
answers
186
views
Google Sheets Bucket Monthly Country Data (QUERY?)
I have a Google Sheets spreadsheet of monthly data showing percentages by country. There are a few countries and EU that we are trying to highlight, along with grouping the rest of the countries as &...
- 11
1
vote
1
answer
573
views
Query Importrange with concat - adding 2 of the returned columns together
I am trying to import specified data using query importrange but at the same time I want to reduce need for additional calculation columns and by using concat or something similar to add 2 columns ...
- 325
0
votes
1
answer
360
views
Count Names In Multiple Rows & Group Them By Location In Google Sheets
I've been attempting to use Query to group up and count information in the Attempts column below, but I'm running into walls.
When using a Query formula like below, I seem to be on the right track in ...
- 37
2
votes
2
answers
599
views
Google Sheets Formula for combining dice rolls
The Situation: I'm creating a dice notation "Clean Up" formula, so that similar dice rolls are combined. For example: "1D6+1D6" would become "2d6". To complicate things,...
1
vote
1
answer
187
views
How to convert range text to number format when using QUERY and FILTER
I am using this formula in my example sheet to filter the 5 last columns of data in a chart: =INDEX(QUERY(TRANSPOSE(SORTN(TRANSPOSE(FILTER({B3:U3;B5:U7},B1:U1=A11,B2:U2=A12)),5,0,TRANSPOSE(FILTER(...
- 213
1
vote
2
answers
945
views
Group everything by Column A and have Column B be a comma-delimited list of values
I've got a Google Sheets worksheet with data like this:
Product
Attribute
Product A
Cyan
Product B
Cyan
Product C
Cyan
Product A
Magenta
Product C
Magenta
Product B
Yellow
Product C
Yellow
Product A
...
