| T O P I C R E V I E W |
| Fanning |
Posted - 07/02/2003 : 10:29:12 AM
Hi,
I have got a txt file, once imported into origin 6.1, it looks like this:
obj.No. Ratio
1 0.85
2 0.866
3 0.771
4 0.867
5 0.927
6 0.868
7 0.89
8 0.885
9 0.903
10 0.851
1 0.852
2 0.869
3 0.778
4 0.865
5 0.931
6 0.868
7 0.891
8 0.895
9 0.9
10 0.85
1 0.852
2 0.871
3 0.78
4 0.864
5 0.934
6 0.868
7 0.89
8 0.904
9 0.897
10 0.848
1 0.839
2 0.861
3 0.778
4 0.85
5 0.922
6 0.856
7 0.877
8 0.899
9 0.877
10 0.831
......
I wonder whether there is an easy way to convert it into a table like this:
obj.No. 1 2 3 4 5 6 7 8 9 10
0.85 0.866 0.771 0.867 0.927 0.868 0.89 0.885 0.903 0.851
0.852 0.869 0.778 0.865 0.931 0.868 0.891 0.895 0.9 0.85
0.852 0.871 0.78 0.864 0.934 0.868 0.89 0.904 0.897 0.848
0.839 0.861 0.778 0.85 0.922 0.856 0.877 0.899 0.877 0.831
......
At moment I am doing it manually in Excel, it is so fustrating. Can anyone help?
Thanks
Fanning |
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 07/02/2003 : 11:56:10 AM
Hi Fanning,
This is easiest way I can think of...
1. Delete column 1.
2. Edit->Convert to Matrix->Expand Columns (Expansion factor=10).
3. Edit->Convert to Worksheet->Direct.
Easy to try at least.
Mike Buess
Origin WebRing Member |
|
|
