Origin has a tool for reducing data by deleting or merging worksheet rows according to a user-defined pattern, or by deleting masked rows.
To open the tool:
The wreducerows dialog box is built upon the wreducrows X-Function.
The data input range.
For help with range controls, see: Specifying Your Input Data
This option is only available when Reduce Method is Delete rows with missing values or Delete rows with masked values.
Check this checkbox to delete the whole row if there is missing or masked value in the reference columns. The reference columns are specified in Reference Columns (Input).
Option depends on your selection of Reduce Method: Delete N rows... (Delete Rows) or Reduce N rows... (Merge Rows). Number of rows to merge or delete.
Option is only available when selecting Reduce Method = Delete N rows, then skip M rows. Specify number of rows to skip.
Available when Reduce Method = Reduce N rows with merged values. Specify value to replace merged data points.
The starting row to merge/delete.
Specify output range.
For help with the range controls, see: Output Results