Split Row and Create New Row

[RichardAlt]

Hi Guys,

How can I split the row and create a new row?

For example. I have this data.

As you can see in Column6 there are rows that need to split, rows 2 and 4.

Column1	Column2	Column3	Column4	Column5	Column6	Column7
Test1	RQS	D	1999/01/25		4604	1
Test2	SDF	D	1999/01/25		0444 & 4604 (split 50 / 50)	1
Test3	GGS	D	1999/01/25		4605	1
Test4	ASB	D	1999/01/25		0444 & 4604 (split 50 / 50)	1

The final output must be something like this,

Column1	Column2	Column3	Column4	Column5	Column6	Column7
Test1	RQS	D	1999/01/25		4604	1
Test2	SDF	D	1999/01/25		444	0.5
Test2	SDF	D	1999/01/25		4604	0.5
Test3	GGS	D	1999/01/25		4605	1
Test4	ASB	D	1999/01/25		444	0.5
Test4	ASB	D	1999/01/25		4604	0.5

Also when splitting rows, Column 7 must be equally distributed to split rows.

[messi007 · Accepted solution]

@RichardAlt,

Please see below:

Hope this helps!

If this solve the need please mark it as solved, it will help others.

Attached the workflow,

Regards