TRIMRANGE function
TRIMRANGE(F:F) - trims a range, removing leading/trailing/all empty rows/cols.
Trim Refs operator
A1.:B10 (leading trim) → corresponds to TRIMRANGE(A1:B10,1,1)
A1:.B10 (trailing trim) → TRIMRANGE(A1:B10,2,2)
A1.:.B10 (full trim) → TRIMRANGE(A1:B10,3,3)
See https://techcommunity.microsoft.com/blog/excelblog/announcing-trimrange-and-accompanying-trim-references/4230202