Based on: Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
How can I rewrite this for use of a comma as separator and remove blank spaces?
Row 1: Albert A. Anderson, Beatrice B. Bargel ->
The desired output on a new sheet:
Row 1: Albert A. Anderson (plus surrounding cells) Row 2: Beatrice B. Bargel (plus surrounding cells)