close
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 102
0.50 103
0.50 104
0.50 105
0.75 106
0.75 107
0.75 108
0.75 109
1.00 1010
1.25 1011
1.25 512
1.50 512
1.50 1013
1.50 2 14
Please help.
全站熱搜