Concatinate more than 50000 rows WITHOUT spaces - Google sheets

Osm 0
Viewed 33

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.

Gif

concatenation google-sheets-formula text google-sheets
1 Answers

best you can do:

=INDEX(QUERY("♦|"&A2:A&"|♦";;9^9))
player00
Related