L
Loris
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
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