An arrayformula affects all rows, so you only need to type the formula once and it affects all rows in that column. If a row is empty, then you can do a length check on a column that would normally be filled, so you can have it show a blank value instead of an error or zero if the row is not populated with anything yet.