I have a big spreadsheet with many columns that got populated from a form with many multiple select items such as countries. I'd need to pivot it, but each comma multi variable cell shows up as a unique entry. I know, classic spreadsheets cannot understand dealing with multiple variables within a cell without splitting it apart. I am trying to avoid that because of how it is structured right now. Airtable was able to understand them & created multiple select fields, but Airtable cannot pivot more than 1 row & 1 column data point. I'm kinda going nuts here with hundreds of Google searches, and dozens of app tests, but I am unable to find some software or webapp that can deal with this.

Anyone have a suggestion? 🙏🙏🙏