LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW CAN I TAKE 2 ROWS AND MAKE THEM EQUAL A PRICE Ron Excel Discussion (Misc queries) 3 April 9th 06 01:37 PM
how do I make the first three rows repeat on top of every page? StardustDave New Users to Excel 2 January 29th 06 10:51 PM
Make a Macro take out rows and add it to new worksheet Vic Excel Discussion (Misc queries) 9 December 2nd 05 03:25 PM
make colour in rows stay Crowraine Excel Discussion (Misc queries) 1 January 28th 05 03:14 PM
How do I make bi-Lingual on a colum in many rows? logengr Excel Discussion (Misc queries) 0 January 22nd 05 10:59 AM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"