All Questions
Tagged with google-query-language split
31 questions
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
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
0
votes
1
answer
1k
views
Can you split a column in query
I have a functioning query, now I'm just looking to split the results of one column into two.
Query:
=QUERY(Sales!A1:I,"SELECT B, A, F, H, G, I WHERE D = 'Projects' and B >= date '"&...
- 23
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
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
...
-3
votes
1
answer
85
views
How to calculate total of partial matches for dataset?
I'm trying to figure out how to calculate when, in a set of rows, any 2 of them match from 3 criteria.
So (6 isn't the correct answer, just an example), I would be trying to calculate how many of the ...
- 39
3
votes
2
answers
1k
views
ARRAYFORMULA is only populating the first row
I have financial data that I am trying to summarize in a format that can be used by a line chart.
The example spreadsheet is here.
In my source data on the left, I have an entry per Date, Symbol, ...
- 745
0
votes
1
answer
2k
views
Unpivot a query in google sheets
I have a query in google sheets that i use to filter table. I then need to UNPIVOT (flatten) this query output to get it in a Database style.
Query:
=query('Variables VAC'!A5:AP500,"select
A,B,...
- 816
1
vote
1
answer
66
views
Looking for a less complicated/more efficient way to aggregate data from a table in Google Sheets?
I have a table with some data that I am trying to organize and be used in different tables. Column 1 is a list of people, column 2 is their services, and column 3 is the employee responsible for that ...
- 49
1
vote
1
answer
181
views
If column A is equal to current month then do. I am needing my formula updated please
I have a formula to count number of times the word "test" is on a certain sheet
=COUNTIF(FILTER('Archived D'!E:E,ISNUMBER(MATCH('Archived D'!H:H,Match!$A$2:$A$12,0))),A2) + COUNTIF('IAD'!E:E,...
- 57
1
vote
1
answer
87
views
concat rows after doing multiple table joins in a Google Sheet
I have created a minimal example sheet at https://docs.google.com/spreadsheets/d/1nrPMDTKD0uHbWkAu-3c9DUoxBptB13lScOe8XI8zxF4/edit?usp=sharing.
I will explain:
issues and recommendations is a list of ...
- 5,893
1
vote
1
answer
270
views
Create new array/rows using CSV in single cell in Google Sheets
Using the cell with CSV as the reference, I would like to create a new array/row set with each variation.
| Original | Desired
| Name | Parameters | Name | Parameters
-...
- 13
0
votes
1
answer
548
views
How to create a comma separate aggregate in Google Sheets?
Given the following data set:
https://docs.google.com/spreadsheets/d/1wr7v93CM_kWygRNHyqMWcBFvd1XXkC5SYbjLjauS4SM/edit?usp=sharing
**people** **channel**
person1 channel1
person2 channel1
person1 ...
- 20.1k
1
vote
1
answer
188
views
How to sum results obtained with VLOOKUP and IMPORTRANGE in Google Sheets?
I'm currently obtaining the result with the formula below, which was nicely provided by player0, but the challenge now is to obtain not only the figure found, but a sum, since the occurrences in the &...
- 2,372
1
vote
1
answer
67
views
Repeat Rows per number of elements in next column
I have the following table:
However, I need to convert it into something like this:
Meaning that I need to repeat the first Cell times the number of elements in the next cell (assuming we will split ...
- 33