Insert Blank Row after Every Row with Data

[KimberlyS]

Is there a way to insert a blank row between every row with data? This is for very large spreadsheets when adding blank rows individually is not an option.

Example:

Data Data Data Data
Data Data Data Data
Data Data Data Data
Data Data Data Data
Data Data Data Data
Data Data Data Data

Needs to look like this:

Data Data Data Data

Data Data Data Data

Data Data Data Data

Data Data Data Data

Data Data Data Data

Data Data Data Data

[Joakim N]

Try this:

InsertBlankLine.xlsm

[KimberlyS]

Awesome. Thank you Jaokim!

[KimberlyS]

Hi again Jaokim, I am in need of this same macro but for an unlimited amount of data. Once in the past you built a macro for me that could process unlimited amounts of data and put the result on another tab. Would this be possible for inserting a blank row inbetween each row of data?

[Joakim N]

Can you show me an example in a workbook what you want showing:
- Start data
- Expected result

It is easier for me.

[KimberlyS]

EXAMPLE.xlsx

Here is an example of what I am looking for. The start data would be on Sheet 1 and the result data is represented on Sheet 2. I would like the number of rows and columns to be unlimited. Thanks!!

[Joakim N]

I hope this is what you are looking for.