I've added a short Python script to my tutorial explaining how to transform a list-in-a-single-cell (in G Sheets) into separate rows. Python is an amazing way to automate your Google Sheets workflows.