Hello,

Using Excel 2007.

Have a column that I pre-formated with consecutive dates running downwards.

Occasionally, next to some date, there is some data.
I chart this data.

On the data page, I would like to coalese and remove the rows that have
a date, but No data for them (leaving the chart, and future chart
updating) unchanged.

How can I remove these "non-data" lines please, without messing anything
else up ?

Thanks,
Bob