| T O P I C R E V I E W |
| hipp4dll |
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?
 |
| 2 L A T E S T R E P L I E S (Newest First) |
| hipp4dll |
Posted - 02/10/2016 : 6:38:21 PM
Thank you snowli. It works perfectly!
|
| snowli |
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
|
|
|
