Hi

I have built a model but need to make a test data set. On every 13th line I have data, but I need to randomly distribute this data across the previous 12 rows (the allocation to each cell needs to be random, but all 12 cells must add up to the value in the 13th cell).

Is there a way of doing this?

Thanks