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.

You can get all the averages in a contiguous block of cells using a formula.
Just tell us what the range is.

Do you want something like this:

B1 = average of A1:A90
B2 = average of A91:A180
B3 = average of A181:A270
B4 = average of A271:A360
etc
etc

--
Biff
Microsoft Excel MVP


"dumchik" wrote in message
...
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.