Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to remove multiple empty rows between grouped sets of data (arrays ranges) but leave only one row line empty between each one

How to remove multiple empty rows between grouped sets of data (arrays ranges) but leave only one row line empty between each one?

Multiple ranges are contiguous in rows of data and would like to remove all the extra lines (anything more than one and only preserve one).

How to accomplish this task with:

Question 1) multiple ranges in only one column?

Q2) multiple ranges in more than one column?

How would you keep two (or specify more) blank rows between each set of data?

KEYWORDS TAGS calc rows empty blank spaces remove delete edit