Origin has a tool for splitting a worksheet into multiple worksheets. You can specify that every n columns be split into a new sheet; that every n rows be split into a new sheet; or that columns that share a column header row label be grouped into a new sheet. The wsplit dialog box uses the wsplit X-Function.
Specify the Recalculate Mode.
The worksheet to be split. Note that starting with Origin 2017b, you can CTRL + select a column range to be split (no need to split the entire sheet).
For help with range controls, see: Specifying Your Input Data
Determine how the worksheet is to be split:
For help with the range controls, see: Output Results
%N: Long Name or Short Name of Reference Column (e.g. LongName, LongName1, etc.)
%C: Dataset Name of Reference Column (e.g. Book1_A, Book1_A1, etc.)
%M: Comment of Reference Column (e.g. Comments, Comments1, etc.)
%U: Units of Reference Column (e.g. Units, Units1, etc.)
%V: Cell Value of Reference Column (e.g. Group 1, Group 2, etc.)
Note that names can be comprised of concatenated variables and include arbitrary text (e.g. "%N=%V" will produce sheets named as "Column Name=Cell Value").
Since Origin 2019b, this option has been set to %V by default to output each subgroup to a new sheet with the group-info sheet name.
@SSG = 1