I work on in a Fire Station and we occasionally have to send Fire Fighters to another station. When the person at the top of the list has been sent to another station they go to the bottom of the list, and everyone else in the list moves up a place.

Can I do this quickly in excel?

Thanks in advance for any help.