| Author |
 Topic  |
|
|
hipp4dll
Japan
3 Posts |
 Posted - 02/10/2016 : 10:57:23 AM
|
OriginPro 2016, Win7 x64
Hello everyone. I have two columns (XY) of data, which the first column contain repetitive data range from row 1 to 14. I only want the row 1 to 14 as first column. In the second column, after row 14, I want to extract every 15 rows of the column until the end of data to a new column. Anyone have suggestions?
 |
|
|
snowli
USA
1379 Posts |
Posted - 02/10/2016 : 4:55:57 PM
|
Could you try if Worksheet: Split Columns work for you.
E.g. Highlight column B and choose Worksheet: Split Columns... menu.
Set the Subgroup method as By Sequential N Rows.
N: 14.
Click > next to Output and choose [<Input>]<input>
It will create C, D, ... columns each with 14 values.
You don't have to delete column B, and rows after 14 in column A. When plotting and analyze the newly created data, it will use the corresponding rows values in column A as X.
In the split column dialog, if you click the arrow next to dialog theme and choose Generate script, you will get the script to do so. You can then run some lt script to delete column b and remove rows after 14.
Thanks, Snow
|
Edited by - snowli on 02/10/2016 5:43:03 PM |
 |
|
|
hipp4dll
Japan
3 Posts |
Posted - 02/10/2016 : 6:38:21 PM
|
Thank you snowli. It works perfectly!
|
|
|
| |
Topic |
|
|
|
Extract row to a new column