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: https://docs.google.com/spreadsheets/d/1QQsiQVrrAZnmvR5dMK0SHIP3xDTObUFMPIHW56QOoMQ/edit?usp=sharing



Related Questions