| T O P I C R E V I E W |
| bo257 |
Posted - 09/05/2002 : 4:34:41 PM
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 |
| 3 L A T E S T R E P L I E S (Newest First) |
| bo257 |
Posted - 09/05/2002 : 5:49:19 PM
Hi Mike;
I made mistake;
youur sugestion does work!
thanks a lot;
Barbaros |
| bo257 |
Posted - 09/05/2002 : 5:44:39 PM
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 |
| Mike Buess |
Posted - 09/05/2002 : 5:25:09 PM
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 |
