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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()