Google Sheets - Add Blank row after every 100 rows of data

[robbertly]

Hello,

Just wondering if any knows if / how this can be done in Google Sheets.

• 10 colums of data with 1,000 rows on a Google Sheets Document
• What forumula can I use to automatically insert one or more blank rows after every 100 data filled rows to break up the large block of data?
• Is there a forumula and if so, where do I put the forumla, is there a vba type system in Google Sheets?

Any help appreciated.

 

[jasonb75]

Is there a forumula and if so, where do I put the forumla, is there a vba type system in Google Sheets?

Formulas can not change or move what is already in the sheet, they can only be used to report on existing data where ever you enter them.
Google sheets uses java script instead of vba. It is possible that there are members of this forum who can write java, but you would likely have more success asking on a dedicated google sheets forum. If you do this (something known as cross posting) please remember to post a link to this thread there (and a link to that thread here).