How to generate increment row based on value of another column

[EJ_Alt]

Hi Guys,

I would appreciate some help with this. I want to generate rows (increment date + 1) based on the value of another column. The value column in this case max of 50. if  >50 create a new row and increment date by 1.

e.g. A is split to 6 rows, B is left, C is split to 3, D is left, E is split to 2 rows (75 = 50+25) 

i tried using the generate rows tool. but hit a snag.

[Ben_H]

Hi @EJ_Alt,

I did it with generate rows and a couple of multi row formulas, I have a feeling there's a simpler way but this is what I did -

Hope that helps!

Regards,

Ben

[EJ_Alt]

Hi @Ben_H , thanks for your solution, its almost right. Is it possible to make the max value in the value column no more than 50? see my final output in the original question

e.g. Person A will be (300/50), 6 rows of 50, Person B is OK, Person C is 3 rows of 50, Peron D is OK, Person E would be 1 row of 50 and 1 row 25.

[JWS]

@EJ_Alt let me know if this is the solution that you are looking for?

[paulfound · Accepted solution]

Hi @EJ_Alt 

Nice little challenge this.

[EJ_Alt]

Hi @JWS ..It worked thanks for your solution

[EJ_Alt]

Hi @paulfound ..your solution also worked. Thanks