I have multiple columns where each column have multiple values separated by | delimiter operator. like this
Column1 Column2 Column3
value1 value2 x1|x2|x3
value3 value4 x4
value5 value6 x5|x6

I have to separate column3 values like this:
Column1 Column2 Column3
value1 value2 x1
x2
x3
value3 value4 x4
value5 value6 x5
x6

I hope my question is clear. I can do this in excel using a simple macro. Can anybody please tell me how to do it in Knime. Thanks in advance!

When I posted this the format is different than the one I saw while writing. So the x2 will be in the cell below x1, similarly x3 below x2 and so on. This is my first question here. Sorry for the inconvenience.

Thanks a lot @ipazin for your answer. Is there any way in which I can slpit two columns on a single node? Or do I have to spilt into two branches from file reader and use one node to split each column. I would like to split both columns on a single node. Is that possible? for more clarity I am attaching the image, the left side is input and right side of it output. I used excel macros to perform this task.