| T O P I C R E V I E W |
| Fulerena |
Posted - 05/11/2015 : 04:16:59 AM
Origin Ver. and Service Release (Select Help-->About Origin): 9.1 and 8.5
Operating System:Windows 7
Hi!!!
My data table has two columns. To separate the cycles the program gives a serie of numbers and a text. In example:
X / Y
Cycle 1 / --
1 / 2
3 / 4
5 / 6
Cycle 2 / --
7 / 8
9 / 10
I need to transform it into a separate columns (sometimes 50 cycles), like:
X1 / Y1 / X2 / Y2
Cycle 1 / -- / Cycle 2 / --
1 / 2 / 7 / 8
3 / 4 / 9 / 10
5 / 6
I tried different programs but it didnt work:
wxt test:="col(A)[i]>=0 AND col(A)[i]<=24,75" iw:= [Book1]Sheet1 ow:=[C01]Sheet1;
If someone could help I'd appreciate it.Thank you |
| 3 L A T E S T R E P L I E S (Newest First) |
| SeanMao |
Posted - 05/19/2015 : 04:06:18 AM
Hi,
You can use Import Wizard in Origin to import your data into Origin worksheet which can put numeric data into new columns or new sheets once it encountered any non-numeric data in numeric field.
Below is an example about the dialog and results:
To learn about Non-Numeric Data in a Numeric Field Controls in Import Wizard, please refer the page in link below:
http://www.originlab.com/doc/Origin-Help/ImpWiz-ASC-Bin-DataSelPage
Regards!
Sean |
| Fulerena |
Posted - 05/11/2015 : 08:46:39 AM
Thanks, but it is not a solution. I don´t have a constant range. I need to cut and create a new column when the word appears and not in a constant N value.
I don´t know how I can unstack it. |
| SeanMao |
Posted - 05/11/2015 : 05:53:12 AM
Hi,
There is an X function colsplit implemented in Origin 2015 can be used to realize your goal but not available in Origin 9.1.
This post would be helpful:
http://www.originlab.com/forum/topic.asp?TOPIC_ID=19106
Regards!
Sean
OriginLab Tech. Service
|
