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

Asked Sep 28 '17 at 13:57

Active Sep 28 '17 at 14:21

Viewed 1,239 times

I'm running a formula to join, split, and count items in a column.

=query(transpose(split(join(";", filter(Inventory!J2:J, len(Inventory!J2:J))), ";", False)), "select Col1, count(Col1) group by Col1", 0)

It was working brilliantly until I hit this character limit. Any ideas how to get around it?

Also, there is a similar question here, though I couldn't make it work for mine: Google sheets Text result of JOIN is longer than the limit of 50000 characters

edited Sep 28 '17 at 14:21

user1211

asked Sep 28 '17 at 13:57

J Hawke

See answers: here: https://stackoverflow.com/questions/22368544/new-google-spreadsheet-concatenate-limit-50000-characters – Max Makhrov Sep 28 '17 at 14:26
Yes, I saw that. Hoping for a simpler solution. – J Hawke Sep 28 '17 at 15:27
I'm still looking for an answer to this. I was unable to make the script in the above link work in this situation. – J Hawke Jan 08 '18 at 21:48
The question is closed and I can't answer it here. Please see my answer: https://stackoverflow.com/a/48163806/5372400 – Max Makhrov Jan 09 '18 at 08:10

0 Answers0