Reduce-Columns
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
Select the worksheet to be reduce. See also: How to specify your input data
Available only when Merge by Column Labels is selected for Reduce Method. Slect the desired column label row from the drop-down list.
Specify how many columns to delete when Reduce Method is set to Delete N columns, then skip M columns, or how many columns to merge when Reduce Method is set to Reduce N columns with merged values.
Only available when Reduce Method is set to Delete N columns, then skip M columns. Specify how many columns to skip.
Available when Reduce Method is set to Reduce N columns with merged values or Merge by Column Label. Specify value to replace merged data points.
Choose quantities from the flyout menu or enter desired quantities directly. 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 indentified by Merge by column label.
The starting column to merge/delete.
Specify output worksheet. The output columns are labeled with Merge by quantity.
For help with the range controls, see: Output Results