Got to work thanks so much.
Jannie

"Gord Dibben" wrote:

Select column A then F5SpecialBlanksOK

Enter an = sign in active blank cell then point or arrow to cell above.

Hit CTRL + ENTER.

Copy column A and in place Paste SpecialValuesOKEsc.


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 10:52:00 -0700, Jannie worksheet function <Jannie worksheet
wrote:

I have a worksheet with thousands of rows of data. One column has data as
shown below. Notice the blank lines. What I need is a formula that would make
the data look like the column I show next to it. I know iI have seen this
written before but I can't remember the formula to do it. Please Help. Thx.
Jannie
10 10
10
10
10
12 12
52 52
60 60
60
60
40 40
40
20 20