Adding rows to a spreadsheet based on a value in a cell

[racekarr]

This should be an easy one but it has me stumped.
I have a spread sheet with 3 columns. Each row contains information on product inventory:
ITEM DESCRIPTION QUANTITY PRICE
96-a123 Bolt A 3 $3.95
96-a321 Bolt b 2 $2.95
96-a231 Bolt c 5 $1.95

What I want to do is create new rows based on the number in the third column and change the number to 1 (since the Item will have a row of it's own now). The spreadsheet could be 100 rows or more. The end product would look like this:
ITEM DESCRIPTION QUANTITY PRICE
96-a123 Bolt A 1 $3.95
96-a123 Bolt A 1 $3.95
96-a123 Bolt A 1 $3.95
96-a321 Bolt b 1 $2.95
96-a321 Bolt b 1 $2.95
96-a231 Bolt c 1 $1.95
96-a231 Bolt c 1 $1.95
96-a231 Bolt c 1 $1.95
96-a231 Bolt c 1 $1.95
96-a231 Bolt c 1 $1.95

 
Thanks, any help would be greatly app.