How to insert a string every N rows in a spreadsheet?
If you wanted to skip a row or every other row or every 10 rows and put a X in a column, the way to do it is to use the following formula. This is useful when you want to filter certain data thats in a pattern. You can use this formula in one column, then filter this column to show or ignore the X.
=IF(ROW()/2=INT(ROW()/2),"X","") - Note that you have to change the number 2 to the number of rows you want to skip and the letter X to the string you want it to populate.