Help & Support
Send Feedback
STACKARRAY
Until now stacking many columns into a single one was a cumbersome process. Here is a formula seen in the web to stack columns with native Google Sheets function: =QUERY(ArrayFormula(SPLIT(TRANSPOSE(SPLIT(textjoin("-",TRUE,TRANSPOSE((A1:H1&","&A2:H5))),"-")),",")),"Select * where Col2<>''") Not very comprehensive, isn't it? Use =STACKARRAY(your_array) and stack your columns instantly wherever you need it in your spreadsheet. Without altering the initial array.
Works with
Install
Overview
Until now stacking many columns into a single one was a cumbersome process. 
Here is a formula seen in the web to stack columns with native Google Sheets function:
=QUERY(ArrayFormula(SPLIT(TRANSPOSE(SPLIT(textjoin("-",TRUE,TRANSPOSE((A1:H1&","&A2:H5))),"-")),",")),"Select * where Col2<>''")

Not very comprehensive, isn't it?

Use =STACKARRAY(your_array) and stack your columns instantly wherever you need it in your spreadsheet. Without altering the initial array.
Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu