Thread: add blank rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
climate climate is offline
external usenet poster
 
Posts: 91
Default add blank rows

Hi
I have 3 columns contains date 4 example below(left) ,but with missing
dates, would you please help me how can i add row or cell blank between them
and get right columns
col1 col2 col3 col1 col2
col3
1 10 01 1961 1 10 11 1961
2 11 01 1961 2 11 11 1961
3 14 01 1961 3
4 18 01 1961 4
5 05 02 1961 5 14 11 1961
6
7
8
9 18 11
1961

thank's
best regards
raymon