Split a row to multiple rows according to one cell

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!

Help pls :slight_smile:

Here’s one way to do it:

2018-10-29%2016_15_10-KNIME%20Analytics%20Platform

SplitCellUngroupExample.knwf (9.1 KB)

4 Likes

Thank you very much!
@ScottF