I know we all love to hate multi-select picklists, but I think they exist for a reason, even if that reason is to put $1 into @Steve Molis's swear jar ;) here's a solution for how to handle them productively in Google Sheets for complex data cleaning/migration situations. I'm pretty jazzed about this one! I'd love to hear from you if you give it a whirl! https://thedataarealright.blog/2021/11/03/how-to-populate-multi-select-picklists-in-google-sheets-and-salesforce/
