arraysgoogle-sheetsflatten
Flatten only non empty cells refrence range once
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)<>"")
Make a copy of the example.
Solution
UPDATED!
this is now much simpler with =TOCOL(A2:B,TRUE)
Use
=QUERY(FLATTEN(A2:B), " where Col1 is not null ",0)
- Windows Batch - How do I create an array with a unique set of values?
- Combined two arrays and the result returned has an empty key and value
- How to looping number of columns same as value of array in php
- Array of objects - how to group items by property and squash data from each of grouped items into 1
- How to initialize a mutable array in Zig?
- How to get the number of elements in a JSON array?
- unable to fill an array with numbers from input in java
- Add a new element to an array without specifying the index in Bash
- How can I join elements of a Bash array into a delimited string?
- How to check if a multidimensional array is empty or not?
- Get a subset of elements from a flat array starting from one value and ending at another value
- Get array values between two vlaues
- Receive values from array between other values
- Get rows from a 2d array from one nominated column value to another
- How to filter array by value between two arrays with more object with javascript?
- Get all values from a flat associative array from a start key to an end key
- Get the last item in an array
- Pandas DataFrame from a JSON object
- Filtering array strings with Numpy
- How to return Array<Array<String>>'s descendant's same elements?
- How to generate all possible binary sequences of a set length --given set portions of the sequence
- JavaScript array reduce start from index
- How to to loop through portion of Array in Swift
- Can I decrease an array index by 1 and loop back to the end in a single line?
- Convert bash array to JSON and write to file
- Why is Numpy converting an "object"-"int" type to an "object"-"float" type?
- Mean Squared Error in Numpy?
- transform tree from db format to json format in javascript
- Concatenating a sequence of std::arrays
- algorithm to detect pools of 0s in a matrix