I have a table of data that displays Mothers Name in Column A and Children
in a column B

Where one mother has multiple children I have been entering all the children
in a single cell, seperated by using Alt+Enter

How would I seperate the contents of the cells in column B so that each
child occupies an individual row?

Thanks

Andy