I never like deleting data <bg. It's usually too difficult to get back if/when
you need it.

But if the original poster wants to fill those cells with the values from above
(for any reason), Debra Dalgleish shares how to do that, too:

http://contextures.com/xlDataEntry02.html
and here (as a video):
http://www.contextures.com/xlVideos01.html#FillBlanks

On 07/14/2010 12:39, Ron Rosenfeld wrote:
On Wed, 14 Jul 2010 12:30:20 -0500, Dave Peterson
wrote:

I wouldn't do this.

It may screw up any sorts/filters/charts that you decide you want to use in the
future.

Instead, I'd leave the duplicated values, but hide them using conditional
formatting.

I see you had the same idea I did. Yours was posted first but I
didn't see it until after I had posted mine.


--
Dave Peterson