Hi emperial,
Origin 6.0 is too old, and I even don't have on my computer.
Anyway, I have tried with the current version (Origin 8.6), and show the screenshot below.
The procedure is as follows:
1) Extract One Row with Header: Using the Worksheet Query tool ("Worksheet: Worksheet Query" menu),
and extract a row with a specific time. (Book2)
2) Transpose: Using Transpose tool ("Worksheet: transpose" menu) on this one row worksheet
(with options to let the First Column go to the long name).
I think in your version, you need to do 1) manually; to do 2) by a script which you need
to create some script, or with some manual works, I suspect.
Hope this is helpful.
--Hideo Fujii
OriginLab
P.S. If you want to change the first column in Book3 above with "mm" to a numeric column, you can make a script like below:nr=wks.maxRows;
range c1=col(1);
for(ii=1;ii<=nr; ii++) {
str1$ = c1[$(ii)]$;
pos = Search(str1$,"mm");
c1[$(ii)]$=Left(str1$,pos-1)$;
}
c1.col.format=1;
