Is it possible to have a script delete a row if it doesn't have something in column B or F

I am looking for a script that will look at row B and F, and if there is nothing in one or the other it will delete the row... Is this possible?

So in English, if There is something in B but not in F it will be left alone, and visa versa...

Also, is there a way to make it so that if there is something in B, to copy something from one cell down up in N, then delete the row under it?

Attached is a workbook I am working with so you have an idea of what I'm trying to do.

Thanks.

Hello..

You want that:
if B is empty and F is empty then delete that row
if B has data and F is empty or the reverse the do not delete... Is this what you want?

I have done the first part ie. deletion part. The second part you said I m not clear with it. Pls can you explain it with an example?
Mean while you can check the deletion part...

POS2.xlsm

Originally Posted by jraj1106

I have done the first part ie. deletion part. The second part you said I m not clear with it. Pls can you explain it with an example?
Mean while you can check the deletion part...

Attachment 155025

Ok, This is what I need.

You see the file, There are two rows I need.

Lets take Row 6 and row 7 for this case, Row 6 needs to stay in tact. Row 7 needs to stay in tact too, but what I need is from row 7 to be placed into row 6 is Column N, which is the date.

From there, I need all columns that don't have information in them deleted.

Also I've noticed that there are two things out of alignment, E and F need to be put under D and E in row 7.

I hope this makes sense.