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 - flatten

How to move multiple lines in a google sheet onto just 1 based on the date?

I have many rows with data like below. I would like to end up with rows that have a single date in one column and the next column contains concatenated info of the other rows, like so: 1/20/2022 Tel...
test-img

JP Douma

split

pivot

google-sheets-formula

substitution

flatten

Votes: 0

Answers: 1

Latest Answer

try: =ARRAYFORMULA(SPLIT(SUBSTITUTE(TRIM(FLATTEN(QUERY(QUERY(A2:B; "select max(B) where B is not null group by B pivot A");;9^9))); " "; "×"; 1); "×"))
test-img

player0

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

Creating high and low balance calculations from a dataset

I have a list of currency trades, and from this I need to calculate the high and low points of the balance of each currency. I have created a simple example in the Sheet below: https://docs.google.com...
test-img

Dan

if-statement

google-sheets

google-sheets-formula

sequence

flatten

Votes: 0

Answers: 1

Latest Answer

try: =INDEX(QUERY({QUERY(FLATTEN({B2:B, D2:D}), "where Col1 is not null", ), MMULT(--TRANSPOSE(IF((SEQUENCE(1, COUNTA(A2:A)*2)>=SEQUENCE(COUNTA(A2:A)*2))*( QUERY(FLATTEN({B2:B, D2:D}),...
test-img

player0

Recursively flatten a deeply-nested mix of objects and arrays

I'm trying to flatten a data object that contains mixed content (JavaScript within a React application). I just need the keys of every parent and child in the object; I don't necessarily need the valu...
test-img

patrickrso

javascript

recursion

javascript-objects

flatten

Votes: 0

Answers: 2

Latest Answer

This isn't the prettiest code I've ever wrote. Unfortunately it does get everything const flattenData = (data) => { let results = []; const recursive = (data) => { Object.keys(data) ...
test-img

Oyyou

Posts

Questions

Blogs