View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dumchik dumchik is offline
external usenet poster
 
Posts: 1
Default how to delete blank cells between those with entries

This is the set up. Column A has 2160 entries of daily data. Column B has
been created by averaging consecutive sets of 90 entries in Column A,
entering those averages on every 90th row of Column. I need to copy the
values in Column B and collapse them, by deleting the 89 blank cells between
each, at the same time. I know how to copy values as opposed to functions--i
have forgotten how to get rid of the blanks between occupied cells.