how to delete blank cells between those with entries

[dumchik]

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.

 

[T. Valko]

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