Automating Name Extraction from Comma-Separated Lists in Excel

Hi all, could anyone help me. I have a list in a workbook where a cell per row contains a comma separated list of names. I want to have those names (of every row) in another sheet in the workbook. Any tips on how to automate this in clay?