Flatten only non empty cells refrence range once-CodePudding

Home > Blockchain > Flatten only non empty cells refrence range once

Flatten only non empty cells refrence range once

Time：08-16

I have two columns A2:B with empty and non empty cells, I want to achive a similar result to the formula in D2 but refrence the range A2:B once in the formula. =Formula(Range)

=FILTER(FLATTEN(A2:B),FLATTEN(A2:B)<>"")

CodePudding user response：

Use

=QUERY(FLATTEN(A2:B), " where Col1 is not null ",0)

Page link：https//www.codepudding.com/Blockchain/512274.html

Prev:Select random cell from non-adjacent cells/columns

Next:How to filter by multiple columns with OR strings...and nested OR within column?

Tags：

arrays

google-sheets

flatten

Links：
CodePudding