"Blank" Lines Elimination ?

[Bob]

Hello,

Using Excel 2007.

Have a years worth of data arranged by Date in Col A, and a numerical
value in Col B for many, but not all, of the dates.

The dates are sequential, from Jan 1 thru Dec 31

However, there are many dates with no data.

How can I clean up the spreadsheet so that it only contains the dates
in Col A that actually have a data value for it (in Col B) ?

e.g., the lines with no data would be eliminated.

I would then like to graph the dates/data; any potential problems if I
do the above first ?

Thanks,
Bob

 

[DanielCo]

Hi,
Select all lines. Use autofilter to select blank cells in col B. Select
visible cells only. Right click in selected rows and click "delete
rows".
Regards.
Daniel