| T O P I C R E V I E W |
| olheiser |
Posted - 05/04/2004 : 5:56:52 PM
I am using Origin 7 and I have data that is in the form:
BEGIN 0
5 -2
4 -1
3 0
2 1
END 0
BEGIN 1
4 -2
2 -1
3 -4
5 -3
END 1
BEGIN 2
and so on. What I want to do is turn these two columns of stacked data sets into a bunch of columns that look like:
5 -2 4 -2
4 -1 2 -1
3 0 3 -4
2 1 5 -3
Thanks in advance,
Tyson
Edited by - olheiser on 05/04/2004 6:31:40 PM |
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 05/04/2004 : 6:23:02 PM
It would help to know your Origin version.
...However, I think you can do it with ASCII Options available in all versions. Start with a blank worksheet and select File->Import->ASCII Options.
File Stucture...
Delimiter: space?
Automatic Determination of column types: check
# lines used for structure testing: 3
When non-numeric is found in numeric fields: Start new Worksheet/Column
File Header...
Skip main header: 0 lines
Auto determine to skip more lines: selected
Max # of line etc.: doesn't matter
# of Columns: Unknown
Import into Worksheet as: New Columns
Other Options... All unchecked.
You'll probably end up with a couple of garbage columns on the right but those settings worked with your data example.
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 05/04/2004 6:50:58 PM |
