Split column values to new record without repeating initial column's data

[ssphv]

Hello,

I have a data with 20 columns. Last column have comma separated values.  I would like to split values in last column to new row. 

Column1	Column 2	Column 3	…………				Column 20
123	456	789					258, 369,125,869,555,769
111	2222	536					369,452,127,699,56423, 258631, 6666,7777
1	2	3					5,6,7,8, ……………….50

Below is the output what i'm looking for. ' Text to columns' can be used to split into rows but it splits with repeating values from columns 1 to column 20. If the values in column20 are greater than 20, they must be split into new record and into different columns in new record.For example, from the above table 3rd row last column(contains integers from 5 to 50)  must be split into 3 rows, 6 to 25, 26 to 45 and 46 to 50 

Column1	Column 2	Column 3	………	….					Column 20
123	456	789							258
369	125	869	555	769
111	2222	536							396
452	127	699	56423	258631	6666	7777
1	2	3
6	7	8							25
26	27	28							45
46	47	48	49	50

Any suggestions or guidance will be helpful. Thank you in advance!

[jasperlch · Accepted solution]

Hi @ssphv 

The workflow attached should achieve when you need and it will accept columns with any column names.

[ssphv]

That's working as expected. Thank you!