Splitting rows in a table

[jcicca]

Hi

I would appreciate any assistance with splitting (some) rows in a table, such that the values in the original row are split between the original and newly created row. 

It is best explained visually below and in the attached Excel file, which has further notes included. The rows which are to be split will have a known percentage to use for the split - as you can see, this percentage may be different for each row 

  

Thanks a lot!

JC

[fmvizcaino · Accepted solution]

Hi @jcicca ,

I tried to comment as much as possible to help you understand my line of thought.

Let me know if you have any doubts about it, please.

Best,

Fernando Vizcaino

[jcicca]

Thanks a lot Fernando for such a prompt and useable reply. 

It looks like it will work perfectly, and it's simple to follow, even for my newbie mind!