/
B4 - Join Worksheet
B4 - Join Worksheet
Sample OPJ to download to try: B4 Folder of 92DemoOthers.opj
Append Worksheet
Worksheets can be joined side by side or by adding rows in Origin 2015.
How to:
- When a worksheet is active, select menu Worksheet: Append Worksheet
Join Worksheet by Matching Column
The x-function, wjoinbycol, enable joining worksheets by the matched column in Origin 2015.
Detailed Documentation: Please refer the wjoinbycol help page
How to:
- When a worksheet is active, open the Script Window (from menu, Window: Script Window) if it is not already open.
In the Script Window, enter script below and press Enter
wjoinbycol -d
Join Worksheet by Matching Labels
The x-function, wjoinbylabel, enable joining worksheets by the matched label (worksheet headers)
Detailed Documentation: Please refer the wjoinbylabel help page
How to:
- When a worksheet is active, open the Script Window (from menu, Window: Script Window) if it is not already open.
In the Script Window, enter script below and press Enter
wjoinbylabel -d
, multiple selections available,
Related content
C3 - Remove/Combine Duplicate Rows
C3 - Remove/Combine Duplicate Rows
More like this
2016 Worksheet
2016 Worksheet
More like this
Excel Import Improvements - Partial Import, Sheet selection in Theme file, and Reimport of Multiple Sheets
Excel Import Improvements - Partial Import, Sheet selection in Theme file, and Reimport of Multiple Sheets
More like this
Importing OPJ
Importing OPJ
More like this
Copy & Paste Formula, Label Rows
Copy & Paste Formula, Label Rows
More like this
C3 - Pivot Table with More than 1 Source for Column or Row
C3 - Pivot Table with More than 1 Source for Column or Row
More like this