View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AskExcel AskExcel is offline
external usenet poster
 
Posts: 19
Default make it 12 rows from 1 row

hi,
i have 1000 rows and each row i need to divide by 12 so that it will become
12 rows.

for example :
from this :
class qty
10 1200
20 1000
....
....
...

to this:
no class qty
1 10 100
2 10 100
3 10 100
4 10 100
5 10 100
6 10 100
7 10 100
8 10 100
9 10 100
10 10 100
11 10 100
12 10 100