NoDataNoBusiness
•  341
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
Reviews
Language:
Sort by:
Profile Picture
A User of STACKARRAY
May 20, 2020
Superb Addon... Work as described, really helpful
Is this review helpful?
Yes
No
Profile Picture
Josef Moffett
April 23, 2020
Didn;t work at all - says there is no such function as "STACKARRAY()" when typing into the spreadsheet even after multiple refreshs (and the STACKARRAY is visible in the Add Ons menu)
Is this review helpful?
Yes
No
Profile Pciture
A user of STACKARRAY
April 28, 2020
Hi Josef, It's probable that you didn't enable the add-on for the current document. If you open a new spreadsheet, don't forget to go to Add-ons > Manage Add-ons and in the top-right corner of the STACKARRAY item , choose the option "Enable in this document"
Profile Picture
A User of STACKARRAY
April 13, 2020
Does *exactly* what I need, thanks! I sometimes need to combine multiple horizontal columns into a single vertical column, and STACKARRAY lets me do this formerly labor-intensive task in seconds.
Is this review helpful?
Yes
No
1-3 of 3
Additional information
NoDataNoBusiness
Terms of Service
Search
Clear search
Close search
Google apps
Main menu