I have an automatically generating list of rows with multiple text items within them separated by a
, (ColA). I'm trying to automatically split and transpose each row, where all responses end up in the same column B.
Bonus if the repeating text items in Column A could only be listed once in Column B along with a count of their occurrences in Column C. No worries if that bit isn't possible though.
Example sheet here: https://docs.google.com/spreadsheets/d/1Gelwp2eSFNHIc9pZLW2YwnoKHxid3faKrXHWDxYZcZI/edit?usp=sharing
I found a similar question here that was answered with a script, but I couldn't figure out how to fit it to my purpose.