So, I want all the values in these cells to move up when I clear cells.

Like this:

324a2aa5a1eb45189c1e360331bd7590.png

When I delete the "Joe" row:

d47ed7be0e513788666a6bd3cbeb5e2f.png

The rest of the values should move up:

9fb18459fe93e9e87dba336e2fbc8eaa.png


How do I do this?