Dave Peterson wrote:
Maybe...

Is your data in column A text or formulas? Are those blanks really empty cells?

There are no formulas within the worksheet, just numbers and text.

The blank cells are completely empty.

Thanks.