I would like to take a very large set of rows and columns of cells and rearrange them as one long column. is that possible with a formula?
From this
to this
CodePudding user response：
use this:
=QUERY(FLATTEN(D:G); "where Col1 is not null"; )
I would like to take a very large set of rows and columns of cells and rearrange them as one long column. is that possible with a formula?
From this
to this
CodePudding user response：
use this:
=QUERY(FLATTEN(D:G); "where Col1 is not null"; )