Since there is no direct way to add rows in between rows, the method covered in this article are workarounds to make this happen, And if you’re comfortable with VBA, then you can do this with a single click.
In this tutorial, I will show you some really simple ways to insert a blank row after every row in the existing dataset (or every nth row).