collapsing rows

[Jim S.]

I have a column of information that has some blanks and need a formula to
collapse the rows so there are no blanks. Does anyone know if there a way to
collapse rows that have no information?

 

[Pete_UK]

You could apply a filter to a column where you have some blanks, and
on the filter pull-down choose "Non-blanks" - this will be at the
bottom of the pull-down list.

Hope this helps.

Pete

 

[Jim S.]

I am looking to do this as a formula. I have a column of dates with earnings
associated with these dates in the next column. Some of the dates are within
the same month and I need to sum the earnings for each month and put into
another column without having a blank row.

 

[Otto Moehrbach]

Jim
Not sure that I understand everything you are saying, but if you sort
the whole data range by one of the columns that contains the blanks, all the
blanks will be put at the bottom. The end result is what I think you want.
HTH Otto

 

[Pierre]

I am looking to do this as a formula. I have a column of dates with earnings
associated with these dates in the next column. Some of the dates are within
the same month and I need to sum the earnings for each month and put into
another column without having a blank row.

I think a macro here would be your best friend. Assign it to a
control box or a hot key.

Pierre

 

[Gord Dibben]

In addition to Otto's suggestion.

Maybe just remove the blank rows entirely?

Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Row


Gord Dibben MS Excel MVP