| Author |
 Topic  |
|
|
jn10
1 Posts |
 Posted - 03/09/2020 : 10:37:57 AM
|
Origin Ver. and Service Release: OriginPro 2019 (64-bit) 9.6.0.172
Operating System: Windows 10
Hi,
I have an origin project with multiple workbooks, all with the same format, and I'd like to combine the data from one column from each workbook into a single workbook.
i.e. I have workbooks 1-100, with columns X and Y. Column X is exactly the same across the workbooks, whilst column Y has the variable data. I'd like to create a new workbook with the X column at the start and then the Y columns 1-100.
Is there a simple way to script this, as currently I've been using the "Copy column to" dialogue for each Y column, which is quite time consuming.
Many thanks |
|
|
YimingChen
1592 Posts |
Posted - 03/09/2020 : 1:52:01 PM
|
Hi,
To append same columns from multiple workbooks, you can select from menu Worksheet -> Append Worksheets. In the dialog, you can select Specific Columns to only select one column of each worksheet and combine.
James |
 |
|
| |
Topic |
|
|
|
Columns from multiple workbooks into single book