"Blank" Lines Elimination ?

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
 
Back
Top