Post #2943392
2026-04-28 15:11 UTC
@samhenrigold@hachyderm.io a slow formula, so not for repeated use above several thousands of rows, but =drop(filter(A:A,A:A<>""),1) outputs an array of non-empty cells in column A, less the first row.
Replies (1)
-
@yesh@tech.lgbt 2026-04-28 15:12
@samhenrigold@hachyderm.io And faster, =drop(A:.A,1) gives everything from row 2 through the final row with data.