Adding intermittent rows to a spread sheet
 

This is the structure of the file I have. It is one line per product
No Desc Price Qty %
1 a $1.00
2 b $2.00
3 c $3.00
4 d $4.00
5 e $5.00

What I need to get to is this. Our new computer system exports and imports
price lists from excel via .csv files (for easier maitenance). I have not
found an easy way to give myself the extra rows for each item. This would
not be an ordeal normally but I have appprox 45000 part number records that I
have to break up and do this with

No Desc Price Qty %
1 a $1.00 5 4%
1 a $1.00 10 8%
1 a $1.00 20 12%
2 b $2.00 5 4%
2 b $2.00 10 8%
2 b $2.00 20 12%
3 c $3.00 5 4%
3 c $3.00 10 8%
3 c $3.00 20 12%
4 d $4.00 5 4%
4 d $4.00 10 8%
4 d $4.00 20 12%
5 e $5.00 5 4%
5 e $5.00 10 8%
5 e $5.00 20 12%

Does anyone have any suggestions how I could do this? Thank you in advance
for your help

Adding intermittent rows to a spread sheet
 

Quick and easy way, without writing macro to insert rows and date...
Fill qty and percent in the first row and copy down for 5 and 4% in first set.
Copy the data rows and paste below existing table then change first row of
second set to 10 and 8% and copy down, then paste third set and change first
row to 20 and 12% and copy down again. Then select all and sort by no then
price to list as in your sample.
The easiest way to copy down here would be to double click on the AutoFill
handle - the little black square at the bottom right of the selection border.
Would look like this before sort:

No Desc Price Qty %
1 a $1.00 5 4%
2 b $2.00 5 4%
3 c $3.00 5 4%
4 d $4.00 5 4%
5 e $5.00 5 4%
1 a $1.00 10 8%
2 b $2.00 10 8%
3 c $3.00 10 8%
4 d $4.00 10 8%
5 e $5.00 10 8%
1 a $1.00 20 12%
2 b $2.00 20 12%
3 c $3.00 20 12%
4 d $4.00 20 12%
5 e $5.00 20 12%



"Loris" wrote:

This is the structure of the file I have. It is one line per product
No Desc Price Qty %
1 a $1.00
2 b $2.00
3 c $3.00
4 d $4.00
5 e $5.00

What I need to get to is this. Our new computer system exports and imports
price lists from excel via .csv files (for easier maitenance). I have not
found an easy way to give myself the extra rows for each item. This would
not be an ordeal normally but I have appprox 45000 part number records that I
have to break up and do this with

No Desc Price Qty %
1 a $1.00 5 4%
1 a $1.00 10 8%
1 a $1.00 20 12%
2 b $2.00 5 4%
2 b $2.00 10 8%
2 b $2.00 20 12%
3 c $3.00 5 4%
3 c $3.00 10 8%
3 c $3.00 20 12%
4 d $4.00 5 4%
4 d $4.00 10 8%
4 d $4.00 20 12%
5 e $5.00 5 4%
5 e $5.00 10 8%
5 e $5.00 20 12%

Does anyone have any suggestions how I could do this? Thank you in advance
for your help

Adding intermittent rows to a spread sheet
 

Sort by Number and then by Qty... sorry - saw I had typed the wrong thing
just as I hit post...

"Loris" wrote:

This is the structure of the file I have. It is one line per product
No Desc Price Qty %
1 a $1.00
2 b $2.00
3 c $3.00
4 d $4.00
5 e $5.00

What I need to get to is this. Our new computer system exports and imports
price lists from excel via .csv files (for easier maitenance). I have not
found an easy way to give myself the extra rows for each item. This would
not be an ordeal normally but I have appprox 45000 part number records that I
have to break up and do this with

No Desc Price Qty %
1 a $1.00 5 4%
1 a $1.00 10 8%
1 a $1.00 20 12%
2 b $2.00 5 4%
2 b $2.00 10 8%
2 b $2.00 20 12%
3 c $3.00 5 4%
3 c $3.00 10 8%
3 c $3.00 20 12%
4 d $4.00 5 4%
4 d $4.00 10 8%
4 d $4.00 20 12%
5 e $5.00 5 4%
5 e $5.00 10 8%
5 e $5.00 20 12%

Does anyone have any suggestions how I could do this? Thank you in advance
for your help