Google Sheets - Text result of JOIN is longer than the limit of 50000 characters

by J Hawke   Last Updated January 09, 2018 17:03 PM

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?

Sample, editable shared spreadsheet here:

Related Questions

Copying values between google sheets

Updated July 26, 2018 21:03 PM