I am looking to delete Blank cells down multiple columns with a single
function or formula. I know the ISBLANK function exists.

But can I delete a cell if it is Blank using a formula ?
In the example below, if row denotes Ranks:

RANK A B C
1 x y
2 r t
3 a b
4 n

I want to rank across the various columns A B C by deleting blank cells and
moving the nonblank cells up

A B C
1 x r y
2 a b t
3 n
4