Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the spreadsheet below. Note that there are cities (usually taking up 3 to 5 rows). I'd like to insert a blank line after each group of cities. So for instance, I'd like to have the following:

AkronOH
AkronOH
AkronOH

AlbanyGA
AlbanyGA
etc...

Is there an easy way to accomplish it? (e.g. easier than doing it manually).

enter image description here

share|improve this question
up vote 1 down vote accepted

Yes. Subtotal on ServerName, Filter on Subtotal rows (eg Text Filters, Contains 'Count') and hit Del. Subtotal again with Remove All.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .