python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - google-query-language

How to turn a pivoted forecast with columns into a formulaic row-based output?

Wondering the best way to do this in Sheets - I have a forecast with strings in column A, and 10 columns worth of forecasted data. So column A would have the store name, columns B-K would have the for...
test-img

fbnhost1

arrays

google-sheets

split

flatten

google-query-language

Votes: 0

Answers: 1

Latest Answer

use: =INDEX(QUERY(SPLIT(FLATTEN(A2:A7&"×"&B1:1&"×"&B2:7), "×"), "where Col2 is not null"))
test-img

player0

Google Sheets QUERY + SUBSTITUTE to convert dot to coma

Here is my Google Sheets : My datas I would like to import "QUERY" column M,N,O,P,Q,R into another tab (same sheet) but convert dot "." to coma "," from column Q and R. I...
test-img

Tony

arrays

google-sheets

number-formatting

substitution

google-query-language

Votes: 0

Answers: 2

Latest Answer

Try =query({Hoopzi_FlatFileAllOrdersReportbyLastUpdate!M2:P\arrayformula(1*substitute(Hoopzi_FlatFileAllOrdersReportbyLastUpdate!Q2:R;".";","))};"select *")
test-img

Mike Steelson

Query sheet and return Column Headers that match two criteria in a row

I am trying to return an array of column headers based on TRUE values and Item names. Link to sheet <- Clicky Sheet 2: Sheet 1: (desired results) I think I am close but can't rack my brain to sea...
test-img

Kevin P.

google-sheets

split

google-sheets-formula

flatten

google-query-language

Votes: 0

Answers: 2

Latest Answer

use: =INDEX(IFERROR(SUBSTITUTE(SPLIT(TRIM(FLATTEN(QUERY(TRANSPOSE( IF(Sheet2!A2:D=TRUE, SUBSTITUTE(Sheet2!A1:D1, " ", "♦"), )),,9^9))), " "), "♦", " "...
test-img

player0

fill sheet with values if they occure in another sheet

i have 2 sheets: Sheet 1: Sheet 1 Sheet 2: Sheet 2 I want to create a formular that is able to select only the relevant information from sheet 1 as soon as a new entry (Starting with "New Meter I...
test-img

Hector Devough

if-statement

google-sheets

filter

google-sheets-formula

google-query-language

Votes: 0

Answers: 1

Latest Answer

try: =FILTER(Sheet1!B2:I; Sheet1!B2:B<>"") update: =FILTER({Sheet1!B2:C, Sheet1!E2:E, Sheet1!G2:I}, Sheet1!B2:B<>"") or: =FILTER({Sheet1!B2:C\ Sheet1!E2:E\ Sheet1!G2:...
test-img

player0

Posts

Questions

Blogs

Jobs