Add line automatically

I wanted a sql script or excel function that runs the line and when I find "Out of Compliance" add me a new line

    Name        Food from Approved Source (C)   Food Protected from Contamination (C)       
16 HANDLES      Out of Compliance                             Out of Compliance 

on this new line would have:

         Name       Violation       
      16 HANDLES    Food from Approved Source (C)         
      16 HANDLES    Food Protected from Contamination (C)