Want to Split Value

Question

Hi All,

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

.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 Answer

@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.