How to jump to the last cell containing data in a row or column containing blanks?

Is there a way (keyboard shortcut preferably) to jump to the last data cell in a row or column containing blanks?... and selecting the traversed cells eg by holding Shift down?

Ctrl+arrow jumps only to the next data/blank boundary. I've searched various threads and sites for what I thought would be a simple keyboard shortcut, but suspect there isn't such thing.

Any help appreciated.

Try

Ctrl+Shift+End

Ctrl+Shift+End goes to the last cell of the entire data. I would like to jump straight down to the last data cell in the current column only (again, column contains blank cells so Ctrl+Down won't work).

A workaround is Ctrl+Shift+End then Shift+Left back to one column, but if the last data cell in the column is at, say row 3000, but other columns are 5000 rows, then it requires 3 steps: Ctrl+Shift+End, Shift+Left as required, then Ctrl+Shift+Up (or without the Shifts to just navigate).

Simple enough, but I was wondering if there's a one-step shortcut to reduce the chance of messing up data?