Stackarray 3 CRX for Google Sheets
A Free Utilities Add-on
Published By https://nodatanobusiness.com
Stackarray (djkbffiggnmhgchmlejbfmghlidkajof): It combines all the columns of an array into a single column... Read More > or Download Now >
Stackarray for Google Sheets
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 3
- • Price: Freeware
- • Offline: No
- • Developer: https://nodatanobusiness.com
User Reviews
- • Rating Average
- 0 out of 5
- • Rating Users
- 0
Download Count
- • Total Downloads
- 8
- • Current Version Downloads
- 8
- • Updated: July 17, 2019
Stackarray is a free Utilities Add-on for Google Sheets. You could download the latest version crx file or old version crx files and install it.
More About Stackarray
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 =STACKARRAY(your_array) and stack your columns instantly wherever you need it in your spreadsheet. Without altering the initial array.
Use =STACKARRAY(your_array, TRUE) in order to remove all blank cells
To merge an array with only unique values, use =UNIQUE(STACKARRAY(your_array))
To sort the resulting column, use =SORT(STACKARRAY(your_array))
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.
Use =STACKARRAY(your_array, TRUE) in order to remove all blank cells
To merge an array with only unique values, use =UNIQUE(STACKARRAY(your_array))
To sort the resulting column, use =SORT(STACKARRAY(your_array))
