All Questions
58 questions
0
votes
2
answers
62
views
Google Sheets: Repeat "Product SKUs" for 5 rows per SKU in another Sheet
Basically I need to get SKUs in one sheet formatted like this:
Column A
SKU 1
SKU 2
SKU 3
To become formatted like this in another sheet:
Column A
SKU 1
SKU 1
SKU 1
SKU 1
SKU 1
SKU 2
SKU 2
SKU 2
SKU 2
...
0
votes
1
answer
2k
views
Google sheet: splitting dataset rows based on comma separated values in one column and replicating all other columns
I am collecting data from a Google form (data stored to a Google sheet) and to improve data collection some fields may contain multiple values (through checkboxes in the form).
Original data
For ...
- 21
0
votes
2
answers
845
views
Google Sheets: How can I Flatten and Split Data while including multiple columns?
I would like to pull data from Google Sheets form responses that include checkboxes. The checkboxes are output into single column cells by commas.
Data/Form Responses sheet:
enter image description ...
2
votes
1
answer
142
views
Referencing another cell twice in a Google Sheet formula returned error
I want to check where - in a specified range - does a value exist in a Google Sheet. If I already know the column, I would use the "Match()" function to get the row number. But let's say if ...
- 43
2
votes
1
answer
41
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
3
answers
233
views
Sorting/ordering values from smallest to biggest in an array
I have a formula like this : =ArrayFormula(sort(INDEX($B$1:$B$10,MATCH(E1,$A$1:$A$10,0))))
in columns A:B:
a 1
b 2
c 3
d 4
e 5
f 6
g 7
h 8
i 9
...
- 940
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
73
views
Sheet formula to repeat the cells
I have a table where it needs to be repeated whenever there is a value 1 in A column D2 number of times as shown
I have tried with =QUERY(A1:D7,"select C,B where A=1")
https://docs.google....
- 3,198
2
votes
2
answers
600
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
950
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
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
112
views
Using average in array formula [duplicate]
I have the following table structure
Name
Role
rank 1
rank 2
rank 3
rank 4
rank 5
rank 6
Average
Jon
Admin
5
6
7
8
8
9
Tomas
Accountant
3
2
2
9
3
3
Ellie
Admin
2
9
7
3
9
1
Sam
Sales
4
7
3
9
1
8
The ...
- 1,485
1
vote
2
answers
148
views
Google Sheets - Transpose 2D table to 1D List
I'll make an example with a Pokémon table type that corresponds exactly to my data structure.
On the 18 types present line 1 (representing the attacker single type),
I have to convert the duos of ...
- 23
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