As a option, you can have a calculated column on the right side of your data where you can use counta function to count the entries in that row.
Now at the bottom of the data, you can have a Match function to find the row number, see attached:-

finding blank row number.xlsx

Regards,
DILIPandey
<click on below * if this helps>