Report Builder - ignore blank cells in dimension

Hi,

I have an excel spreadsheet using report builder, the input dimension in report builder is set at A10:A1000 but not all the input cell have content, the last ones are usually empty. 

Is there a way to make report builder to skip all the empty cells?