Macro To Create Duplicate Rows

I have to import data and it reads as follows:
TAG cost qty Total
G13-1718 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 4 $600.00
G13-1718 $150.00 2 $300.00

$1200.00

What I need is that each row with more than 1 qty be duplicated and total dollars divided by the appropriate qty, Like the following:

G13-1718 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1718 $150.00 1 $150.00
G13-1718 $150.00 1 $150.00

$1200.00

see attached please