All Questions
Tagged with google-query-language transpose
53 questions
0
votes
1
answer
17
views
Query transpose lookup - returning results
Background:
Google Sheets being used.
I have large (>10k rows), of unorganized sheets of data with ID's and values that I am trying to return values for given ID's. I have no ability to order the ...
0
votes
1
answer
36
views
How to Repeat Transposing A Query Output matching values from a range reference over the whole column in Google Sheets?
I need to transpose column B values where column A values are matching over the entire column.
I tested this but it's not working:
=transpose(QUERY(A2:B,"select Col2 WHERE Col1 MATCHES '"&...
- 779
-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
2
votes
2
answers
398
views
Google Sheets - transpose irregular column data in groups into rows
Much like the problem with the transposing of data in transpose column data I am stuck trying to transpose a set of data with multiple variables. The biggest issue I face is trying to remove useless ...
- 35
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
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
-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
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
68
views
Google Sheet join cells with text placement
Is it possible to have a formula in Google sheet to place the 1st text of the 2nd column next to 1st text of the first column, and the 2nd text of the 2nd column next to 2nd text of the first ...
- 69
1
vote
1
answer
76
views
Join column header with array n times
I am looking to join column headers with their respective arrays any number of times depending on if the cell is not empty and if it has a checkbox.
Link to sheet
I have a formula close but I can't ...
- 1,053
2
votes
1
answer
3k
views
Google sheets - Check all TRUE per row in boolean 2D array with ARRAYFORMULA
I have the following data (created through a ARRAYFORMULA formula):
A
B
C
D
1
TRUE
TRUE
FALSE
TRUE
2
TRUE
TRUE
TRUE
TRUE
3
TRUE
FALSE
TRUE
TRUE
If in a row all values are TRUE, the output for that row ...
- 6,402
2
votes
1
answer
492
views
Convert columns to rows and repeat row labels in google sheets
I am trying to convert table 1 to the format in table 2. How can I do it in google sheets ?
Thank you very much.
Table 1 -
Table 2 -
- 31
1
vote
1
answer
139
views
Google Sheets Arrayformula with some sort of concatenate/textjoin/something similar for all rows
I'm trying to do an arrayformula that goes down all rows. I want it to grab the text from a specific row if the row that it's on meets conditions.
Here's an example of what I'm trying to do: have a ...
- 43
1
vote
1
answer
90
views
Form submissions over time - compare the difference from last submission - Google Sheets
I have a list of answers that comes in through a form in Google sheets like this. Please note that the answers in Column F & G are comma seperated
I would like to end up with a list looking like ...
- 145
2
votes
1
answer
2k
views
Join multiple columns horizontally into one column with ArrayFormula
Sheet:
A
B
C
D
E
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
Currently to join the values horizontally of the columns, I do like this:
=ARRAYFORMULA(IF(A1:A="","",A1:A&B1:B&C1:C&D1:D&...
- 2,177