Q: Concatinate more than 50000 rows WITHOUT spaces - Google sheets I have this sheet Make a copy with more than 50,000 rows in A2:A
The ask
In a single formula, I want to concatenate them with | in a single cell without spaces in between.
Any help is greatly appreciated.


A: best you can do:
=INDEX(QUERY("♦|"&A2:A&"|♦";;9^9))

