delete some rows based on the data

hi all..


i attach Book1.xls to explain what i want to do.

at the sheet 1, "input", is is the original example data before run the marco.
at the sheet 2, "explain output", is is explaination for the marco.
at the sheet 3, "output", is the output i want

please assist. thanks