Multiple row
 

I have a data like following

Power Qty
+0.25 20
+0.50 30
+0.75 40
+1.00 10
+1.25 15
+1.50 17

I want to insert data for each power not exceeding the total quantity of 10
and for each group of 10 quantities; I want to give a number like 1,2,3,4
etc.

Like This:

Power Qty Number
+0.25 10 1
+0.25 10 2
+0.50 10 3
+0.50 10 4
+0.50 10 5
+0.75 10 6
+0.75 10 7
+0.75 10 8
+0.75 10 9
+1.00 10 10
+1.25 10 11
+1.25 5 12
+1.50 5 12
+1.50 10 13
+1.50 2 14

Please help.