The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 worksheet to matrix (direct)		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

bo257

USA
13 Posts
Posted - 09/05/2002 :  4:34:41 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi;

I need to make a contour plot;
right now I have one worksheet with one very long column.
By simply copy and pasting selections from this very long column into many columns I would like to use the build in function of convert worksheet into matrix (direct).
Does anyone know how to select certain rows from one column, copy this selection, create a new colum and paste the selection into this new column with labscript?

Thanks a lot for any help;

Barbaros

Mike Buess

USA
3037 Posts
Posted - 09/05/2002 :  5:25:09 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Barbaros,

Why don't you use Expand Columns rather than a Direct conversion? It seems that will do exactly what you want. Unless your new worksheet columns will have a variable number of rows, in which case we need a few more details.

Mike Buess
Origin WebRing Member
Go to Top of Page

bo257

USA
13 Posts
Posted - 09/05/2002 :  5:44:39 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Mike;

thanks a lot for your quick response;
I just tried your suggestion, but the result is not exactly what I was looking for. I do obtain a matrix with 400 identical rows.
I am trying to copy every 400 rows such that the first new column consists of the rows 1 to 400 of the intial colums, the second new column consists of the rows 400 to 800 of the initial column, the third new column consists of the rows 800 to 1200 of the initial column, etc.
Perhaps it is possible with your suggestion, but it is not clear to me from the manual how to do this; but I will have once more a careful look at this option....

Barbaros
Go to Top of Page

bo257

USA
13 Posts
Posted - 09/05/2002 :  5:49:19 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Mike;
I made mistake;
youur sugestion does work!
thanks a lot;

Barbaros
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000