python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - flatten

Table transformation Google Sheets

I'm trying to convert such table: into such table: First table is very big, and is being changed automatically by another user. I'd like to use Google Sheets' query function. Any idea how? Thanks in...
test-img

raduy

if-statement

google-sheets

transpose

flatten

google-query-language

Votes: 0

Answers: 1

Latest Answer

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

player0

Unwrap/Flatten unbalanced List of Lists with Strings

Given the case I have the following List: ['graph_edges', ['graph_nodes'], ['graph_nodes'], ['graph_edges2', ['graph_nodes2'], ['graph_nodes2']]] And I wish to convert it to something like: ['graph_e...
test-img

Qohelet

python

list

multidimensional-array

flatten

Votes: 0

Answers: 2

Latest Answer

You need to use recursion to account for the fact that the lists can be nested arbitrarily deep: def flatten(lst): result = [] for item in lst: # You can use: # if not isinstan...
test-img

BrokenBenchmark

Python: Convert Nested Array to Newly Formatted Nested Array Based on Column Position

Let's say I have a nested array like so: array = [[1,7], [49, 9], [3, 80], [13, 15]] From the above array, I want to create two new arrays (within a nested array) based on vertical "columns"...
test-img

PineNuts0

python

loops

multidimensional-array

nested

flatten

Votes: 0

Answers: 1

Latest Answer

You can use zip() with list unpacking. This operation assumes that all of the input lists are of the same length, but it does not make any assumptions on the sizes of the input lists otherwise: result...
test-img

BrokenBenchmark

How to customize order of header values that are joined when answer is yes in Google Sheets

How can I modify the equation in this Google Spreadsheet which I found as an answer to another question so that it can allow a user to customize the order of replaced values? Goal Replace "yes&qu...
test-img

MMsmithH

regex

sorting

google-sheets

google-sheets-formula

flatten

Votes: 0

Answers: 1

Latest Answer

use: =INDEX(REGEXREPLACE(TRIM(FLATTEN(QUERY(TRANSPOSE( IF(TRANSPOSE(SORT(TRANSPOSE(A2:D), FLATTEN(A1:D1), 1))="yes", REGEXREPLACE(TRANSPOSE(SORT(FLATTEN(A1:D1))), "(^\d+_)", )&a...
test-img

player0

Posts

Questions

Blogs

Jobs