View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jannie worksheet function Jannie worksheet function is offline
external usenet poster
 
Posts: 1
Default Columns with missing data that needs filled in

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