For a simple column, you can use the TRANSPOSE function. As an example, if you would like to transpose column B of Table 1:
Create a new table (Table 2)
In cell B2 of Table 2 put the formula =INDEX(TRANSPOSE(Table 1 :: $B),1,COLUMN()-1)
Fill that to the right until you have your entire transposed column.
Cut and paste it to where you want it then delete Table 2.
Alternatively, Yvan created a script to transpose a table. I have not used it but here is an excerpt of his from another thread:
There is a TRANSPOSE() function in Numbers '09 but it is not easy to use.
You may go to my iDisk:
<http://idisk.me.com/koenigyvan-Public?view=web>
and download :
For_iWork:iWork '09:for_Numbers09:Transpose.zip
This archive contains two scripts.
One allow you to build a frozen transposed table (was written for Numbers '08)
One allow you to build a living table whose cells's contents will change when the original ones are modified.
It would be your duty to enlarge the table ifrows or columns are added to the source but, as every cells are filled adding new row/column will automatically insert the correct formulas.
Yvan KOENIG (VALLAURIS, France) mardi 8 septembre 2009 15:11:31
