JOIN text result longer than 50,000 character limit

Question

I use the column formula to combine, split, and count .

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

It worked brilliantly until I hit that character limit. Any ideas how to get around this?

Example, editable general table: https://docs.google.com/spreadsheets/d/1QQsiQVrrAZnmvR5dMK0SHIP3xDTObUFMPIHW56QOoMQ/edit?usp=sharing

Also, there is a similar question here, although I couldn't get it to work for mine: Google Sheets JOIN text result is longer than the limit of 50,000 characters