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.
|