Im trying to make a script that help me elimate some useless info on a sheet so I can make some charts faster. I know this is quite a headache now but will save me soo much time after it is done. Here is what I want to happen...

Column B is going to look similar to this

Row 1 : F130201
Row 2 : F130202
Row 3 : F130203
Row 4 : Pumpout
Row 5 : F130204
Row 6 : Jumbo
Row 7 : F130205

It doesn't actually say Row #, I just put that so you new it was the next row. Anyway, this goes on for hundreds of rows. I need a script that will check the contents of column B, if its one that starts with F######, leave it alone, but if it says "pumpout", i want to delete the entire row and shift cells up. If say, row 6 column B says "Jumbo", I want to delete A6 & B6, shift cells up, delete C5:J5 and shift cells up.

Im sorry if this is confusing and/or really difficult but I would so much appreciate someones help with this. Ive been trying to figure it out on my own for quite some time now and I just can't figure it out.