Scarpel Telecom interview question

How would you split a data array or column if a single cell contains multiple values, and you need to normalize them into separate rows?