Skip to content

Instantly share code, notes, and snippets.

@mikaelvesavuori

mikaelvesavuori/SheetsDestructuringFunction.sh

Created June 1, 2023 14:32
Show Gist options
  • Save mikaelvesavuori/1a6c284d1f2301fc86477d153b650989 to your computer and use it in GitHub Desktop.
Save mikaelvesavuori/1a6c284d1f2301fc86477d153b650989 to your computer and use it in GitHub Desktop.
Download ZIP
Destructure semicolon-separated strings in Google Sheets into separate items
Raw
SheetsDestructuringFunction.sh
= {"Destructure issues into separate items"; ArrayFormula(TRANSPOSE( {SPLIT( {JOIN("",{REGEXREPLACE('YOUR SHEET NAME'!W2:W,"\(.*\)","")})}, ";", FALSE, TRUE)}))}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment