Data Tables - Identifying the range

Let’s say I have a single column data table - I need to identify the range in which the values are filled. For example, in the data table candidate names,

The first row is blank.
The next 3 rows are filled
The last 2 rows are blank

So, the answer will be A2:A4.

How do I get this range?

Read the whole thing into a datatable then you can look at which rows in the datatable have values.