App Icon
š—¦š—œš— š—£š—Ÿš—˜ š—•š—Øš—§ š—Øš—¦š—˜š—™š—Øš—Ÿ š—™š—Øš—”š—–š—§š—œš—¢š—” š—§š—¢ š—§š—„š—”š—”š—¦š—™š—¢š—„š—  š—” š— š—Øš—Ÿš—§š—œ-š—–š—¢š—Ÿš—Øš— š—” š—”š—„š—„š—”š—¬ š—œš—”š—§š—¢ š—” š—¦š—œš—”š—šš—Ÿš—˜-š—–š—¢š—Ÿš—Øš— š—”.
Works with:
8,704
Overview
Until now combining 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 =š—¦š—§š—”š—–š—žš—”š—„š—„š—”š—¬(š˜†š—¼š˜‚š—æ_š—®š—暝—暝—®š˜†) and stack your columns or rows instantly wherever you need it in your spreadsheet. Without altering the initial array.


ā–¶ļøŽ š—–š—›š—˜š—–š—ž š—¢š—Øš—§ š—¢š—Øš—„ š——š—˜š— š—¢
https://docs.google.com/spreadsheets/d/1YBMUfJPbePUffEddtpzL2nMstkHzCcf_tjbKu6LR5kI/

š— š—¢š—„š—˜ š—¢š—£š—§š—œš—¢š—”š—¦...

āœ“ Use =STACKARRAY(your_array, TRUE) in order to remove all blank cells

āœ“ Stack row by row instead of column by column =STACKARRAY(ref_to_your_array, , TRUE)

āœ“ To merge an array with unique values only, use =UNIQUE(STACKARRAY(your_array))

āœ“ To sort the resulting column, use =SORT(STACKARRAY(your_array))


Find out more...
https://nodatanobusiness.com/add-ons/stackarray
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
STACKARRAY() for Google Sheets will ask for the permissions shown below. Learn more
STACKARRAY() for Google Sheets will need access to your Google account
This will allow STACKARRAY() for Google Sheets to :
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu