Insert multiple rows

[vane0326]

I would like to know is there a visual code for this?
Look at collumn (A) if the text its by itself and collumn (B) if the number one shows up insert one row BUT if number one is more then insert three rows.

Here is a better example
(A) (B)
COPE & DRAG #1 1
insert one Row
COPE & DRAG #2 2
insert one row

But If it looks like this
COPE & DRAG #2 2
COPE & DRAG #2
Insert row
insert row
insert row

Here is a before:

 

[Nikhil]

Hi,
Can i have the code for dlete rows also which are empty.