Probably one of the biggest complaints that I have against Numbers is that it is unable to transpose data. Meaning that if I type data into table vertically I can’t easily get that data to show up somewhere else horizontally… until now! I found this neat little hack (work-around) on the blog Fury and Frost. It took me a little while to really understand it but I think that my little screencast might help
This is the formula that I used in the video =INDEX(Table 1 :: $A$1:$C$8,COLUMN(),ROW())
If you wanted to reference data in another sheet the formula would look like =INDEX(Sheet 1 :: Table 1 :: $A$1:$C$8,COLUMN(),ROW())
If you wanted to reference data in the same table the formula would look like =INDEX($A$1:$C$8,COLUMN(),ROW())