Is there such an option to preserve only every 10th row in my spreadsheet? It can be Excel or Calc. Quality standards want some noise to be added.
Placed in cell A1, the formula
will repeat with values 0-9 when you fill it down. You can then use filtering to delete the rows that you don't want. Note that the result of the formula will then change if you delete (rather than clear) the rows. (Although filtering doesn't update until you ask it to.)
will only return
Use the analysis toolkits sampling function. It asks you for the input data range, the period you wish to decimate by and the an output cell or range (it does not really care it will fill whatever cells it needs starting at the first one you select)