Want to Split Value

[Rhaldhar]

Hi All,

I have a value .04 in a cell and want to split value in 4 rows like below.

.01

.01

.01

.01

Value can change as like, .07 , (.09), .03 .On these value basis row to be increase and decrease but the rows value should be .01.
Please help to get result.

Thanks,

Rajeev

[Prometheus · Accepted solution]

@Rhaldhar You can use the Formula tool to calculate how many times to split the data (Times to Split) and the values to split into (Split) and follow it up with a Generate Rows tool with the condition expression: RowCount <= [Times to Split]. I used several inputs, but you can use them all and you'll get a new row for every split value.

 

[Rhaldhar]

@Prometheus it works. thanks.