Hello!!! I'm finishing a huge project and I really need your help!
I'm working on a large spreadsheet in Google Spreadsheets and I have multiple columns that contain cells with lists separated by semicolons--I want
to split by semicolon delimiters, while maintaining the surrounding values. I've tried a few scripts (listed below) but I must be doing something
wrong with all of them
I need a solution relatively fast so any help is really appreciated. I'm trying to get my spreadsheet ready for pivot
Basically I'm trying to go from this:
Study 1 | 2010 | Gorilla | Feeding; Resting | Adults
Study 2 | 2003 | Impala | Foraging | Adults; Juveniles
Study 1 | 2010 | Gorilla | Feeding | Adults
Study 1 | 2010 | Gorilla | Resting | Adults
Study 2 | 2003 | Impala | Foraging | Adults
Study 2 | 2003 | Impala | Foraging | Juveniles
I tried this script, which does exactly what I need (just a different delimiter), and received an error: Invalid return. (line 17, file "Code")
Then I tried this script but I wasn't able to modify it to point to the columns that I need to be split (/multiple columns):
Then I tried this: Split single rows into multiple rows depending on whether one cell has values seperated by commas or new lines - Google spreadsheet
and got this error: Unterminated regular expression literal. I tried the second formula on that page and got this error: Script function not found:
I can actually run it for the entire sheet (split all semicolons in all columns) if that's easier. The range of my sheet is A1:BT223. The specific
columns that contain values that need to be split are N-W, AL, BB, BD, and BH.
I'm extraordinarily helpless with these things (I obviously don't know what I'm doing). I'm just really having trouble getting this to work and
I'm sure for someone experienced in this these things it's a piece of cake.
Thank you so much!!! If you can help me I'll be so very grateful!!!