T O P I C R E V I E W |
jn10 |
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 |
1 L A T E S T R E P L I E S (Newest First) |
YimingChen |
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 |
|
|