Split a row to multiple rows according to one cell

[astrauch]

Hi there,

i have a table with a column where multiple values are in one cell separated by a comma.
Is there a way to insert a new row for every value in those cells + to copy the rest of the table to the new rows?

example:

from here:
A B C D,E

to here:

A B C D
A B C E

Thank you for your help!

[astrauch]

Help pls

[ScottF]

Here’s one way to do it:

SplitCellUngroupExample.knwf (9.1 KB)

[astrauch]

Thank you very much!
@ScottF