If A3 is not empty, display blank in O3 and shift list up

If A3 is empty, I want it to return B3 in O3. If A3 is not empty, O3 should return blank and the list should shift up so the following results are displayed starting in O3.
What I’m trying to show is a list of people who have not yet arrived at a party. A3 would indicate if they have arrived or not.
If someone could help me out with this that would be great.

also called filtering :wink:

To stick with columns A and B, you may simply use AutoFilter

To copy to O, see