title: Prep data (separate/split cells into rows)
body: <p>I have a large dataset which format does not fit my analysis, I have an issue:</p>
  
  <p>Several columns contains information delimited by semicolon (e.g. London;bruxelles;copenhagen)</p>
  
  <p>I would need these to be splitted into rows (not columns)</p>
  
  <p>This means I would have a row for each of the cities above for instance</p>
  
  <p>This steps are possible in powerbi, does anybody know how to do this in spotfire?</p>
  
  <p>Thanks
  Kristoffer</p>