New answers tagged

4 votes
Accepted

Text result of JOIN is longer than the limit of 50000 characters

Use a query smush, like this: =arrayformula( substitute( transpose( split( query( filter( substitute( substitute(Data!C2:C, " ", "_")...
user avatar
  • 6,513

Top 50 recent answers are included