title: sheets split multi-line result of importXML
body: <p>I've written a python script to scrape a website for Item ID's for a game, then write them into a google sheet - from there the google sheet concatenates the ID's into one of their website's XML feed links, and I use importXML to pull the data I want to see.</p>
  
  <p>However, it's returning the data in a series of 8+ lines within a single cell, I'd like to split this to return in 8 different columns. Is there a way to do this?</p>
  
  <p><a href="https://i.stack.imgur.com/4aSid.png" rel="nofollow noreferrer">What I Have</a></p>
  
  <p><a href="https://i.stack.imgur.com/y9xgL.png" rel="nofollow noreferrer">What I would Like to See</a></p>