Formulas to remove specific lines of text from a spreadsheet

[visionwindowfilms]

Ive got this list (see attached) and I would like to creat two lists from it, you will notice that some of the text says STANDARD or DELUXE. I was wondewring if there was some function that I could use to delete all the lines that say deluxe from one of the lists then Ill be left with a list with all the standards in (still in the 3 colums). Then I can do the same with a copy of the original list taking out STANDARD. Leaving me with two lists, one with just the standards and another with deluxe.

Is this possible or do I have to manually go in and delete each line?