| Author |
 Topic  |
|
|
kencedric
Germany
13 Posts |
 Posted - 10/27/2011 : 12:01:36 PM
|
Hey
i am using Labtalk script for the first time and i want to convert(transpose) a column to a row.
May be someone can help me.
exemple
Mo 1 8 8 9 9
Di 2 1 1 2 5
Mi 3 2 5 6 8
Do 4 2 0 6 0
Fr 5 3 2 4 8
to
Mo Di Mi Do Fr
1 8 8 9 9
2 1 1 2 5
3 2 5 6 8
4 2 0 6 0
5 3 2 4 8
As u can see, only Mo,Di, Mi, Do and Fr have to move, to be placed in a row...
Thanks for the Help
Cedric |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 10/27/2011 : 1:42:17 PM
|
Hi Cedric,
If you want to transpose a worksheet by a script. you can use a single command (actually an x-function):
wtranspose
--Hideo |
 |
|
|
Drbobshepherd
USA
Posts |
Posted - 10/27/2011 : 3:26:35 PM
|
Is it your intent to only transpose Col 1? If so, you can still use wtranspose, but it is not as simple. Try this:
wtranspose exchange:=1 type:=long col:=1; // Transpose labels and data
del col(A); // Delete column A because it is empty.
wtranspose; // Transpose numeric data back to original order.
This has the added effect of separating your text from your numeric data, which may be useful if you want to refer to your datasets by your text labels.
|
|
|
|
kencedric
Germany
13 Posts |
Posted - 10/31/2011 : 09:19:33 AM
|
Thx Guys
@Drbobshepherd: thanks for ur Help,it works perfectly.
|
|
|
|
fatihk29
Germany
3 Posts |
Posted - 10/04/2012 : 06:30:39 AM
|
Hey guys, also i want to transpose a column to a row, but which is the column taken from another sheet. So, i ll take a column from another sheet and paste it to the active sheet as transposed. for example;
t c (p) p*
7 14 12 12 23 14
8 16 23
6 12 14
*(p) is taken from another sheet, p* transposed of (p)
is there a script for this process. I would appreciate if someone can help me ? |
Edited by - fatihk29 on 10/04/2012 06:39:43 AM |
|
|
| |
Topic |
|
convert or transpose a single column to a row...