How to add new line(s) in cycle ?

[#1]

Table loaded from excel looks like that

Nr. Count. Sum.

1 1 10

2 1 10

3 1 10

4 2 20

6 1 10

7 4 40

11 1 10

I need add line(s) after line where count > 1. Add count - 1 lines with Nr. = Nr.+ 1. and sum = sum/count. To get in final somthing like that:

Nr. Count. Sum.

1 1 10

2 1 10

3 1 10

4 1 10

5 1 10

6 1 10

7 1 10

8 1 10

9 1 10

10 1 10

11 1 10

[Oleg_Troyansky · Accepted solution]

Look at " LOAD ... WHILE" syntax, in conjunction with function "IterNo()" - those two will help you solve the problem.

Oleg

[#3]

Thank, Oleg.