You could use Excel’s “Remove Duplicates” feature, but any duplicate data that is supposed to be there will also get blown away.

To assuredly remove blank rows without removing duplicate data (and maintaining the original order), follow these steps:

1. Locate or insert a blank column
2. Optionally name the column “Order” or leave it blank if there are no headers
3. Type the number “1” in the first row of data
4. Fill down to the last row of data
5. Sort by an actual data field
6. Now the blank rows will be grouped together, so delete the blank rows.
7. Re-sort by the column of numbers from Smallest to Largest.
8. Optionally delete the column of numbers

Need to undo this operation? Here’s how to Insert a Blank Row Between Every Row in Excel

Related how-to’s using the functions mentioned here:

• Excel FILL function
• Excel SORT function

There is no inbuilt way in Excel to insert a blank row between every existing row, but it is achievable without doing it manually.

The process is to create a column with repeated numerals (1 to n, where n is the number of rows with data) equal to twice the number of rows of data (2n) and sort by that column so blank lines appear between each data row.  Here’s how…

1. Locate or insert a blank column
2. Optionally name the column “Order” or leave it blank if there are no headers
3. Type the number “1” in the first row of data
4. Fill down to the last row of data
5. Select and Copy all the numbers just created in that column
6. Paste the selection below the data into the first blank row
7. Sort by the column of numbers from Smallest to Largest.
8. Optionally delete the column of numbers

Tip: if you need multiple blank rows between, repeat step 6 as necessary

Related:

• Excel FILL function
• Excel SORT function