I have somewhere between 20 and 30 columns of varying lengths (dynamic and can change). I would love the ability to be able to stack them in Google Sheets.
I have found some solutions that work until you reach the
concatenate() result limit of 50,000 or whatever it is. Those formulas are as follows:
Again, these both work but are limited and I expect results as long as 200,000 rows long.
A simplified example is:
It would be nice if it rendered only unique values and ignored blank cells. Does not need to be sorted.
BONUS: It would be also very cool if there was a version of this that would only produce cells that have 25 or fewer characters in them!