Numbers, way to transpose columns and rows?
in [Mac Systems]
|
Prev: Where to find AppleŽs list of securitypatches?
Next: Sidebar entries and login items don't use kerberos
From: piscesboy on 3 Aug 2010 21:05 I've got a table that is stuctured like: column1 column2 label 1 value 1 label 2 value 2 label 3 value 3 .. .. .. .. label n value m Where n is a finite value (say between 1 and 20, making 20 distict labels) with m an indeterminate, possibly infinite value, where no limit is imposed. I want to use the labels as column headers, and have the values associated with each label run down the columns. Basically I want to transpose this table on its side so that the labels have the top row of the table and the values run down the table's columns, corresponding to their appropriate label. Help?
From: Vincent Parry on 4 Aug 2010 09:06
On 8/3/10 9:05 PM, piscesboy wrote: > I've got a table that is stuctured like: > > column1 column2 > label 1 value 1 > label 2 value 2 > label 3 value 3 > . > . > . > . > label n value m > > Where n is a finite value (say between 1 and 20, making 20 distict > labels) with m an indeterminate, possibly infinite value, where no > limit is imposed. > > I want to use the labels as column headers, and have the values > associated with each label run down the columns. > > Basically I want to transpose this table on its side so that the > labels have the top row of the table and the values run down the > table's columns, corresponding to their appropriate label. > > Help? Try reposting in comp.sys.mac.apps? |