Search code examples
google-sheetstextconcatenationgoogle-sheets-formulagoogle-query-language

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.

Gif

Solution

  • best you can do:

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