Hello,
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 
To stick with columns A and B, you may simply use AutoFilter
https://help.libreoffice.org/7.6/en-US/text/scalc/01/12040100.html
To copy to O, see
https://help.libreoffice.org/7.6/en-US/text/scalc/guide/specialfilter.html
2 Likes