Origin has a tool for reducing data by deleting or merging worksheet columns. Works on all or partial columns of the worksheet and reduces worksheet columns by deleting or statistically merging.
To open this dialog box:
Controls recalculation of results
For more information, see: Recalculating Analysis Results
The data input range.
For help with range controls, see: Specifying Your Input Data
Option depends on your selection of Reduce Method: Delete N columns... (Delete Columns) or Reduce N columns... (Merge Columns). Number of columns to merge or delete.
Available when Reduce Method = Reduce N columns.... Specify value to replace merged data points.
Choose quantities from the flyout menu. Multiple quantities should be space-separated (e.g. "ave sd" for average and standard deviation). Each quantity will be output to a separate column and labeled with the Merge by quantity.
Only available when Reduce Method = Delete N Columns....
The starting column to merge/delete.
Specify output range. For merge, output columns are labeled with Merge by quantity.
For help with the range controls, see: Output Results