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())
Check out the video!
Sign up for the full feed RSS to know what's going on the minute it happens or sign up for templates via email!
Subscribe Via RSS 
Subscribe Via Email
Subscribe to:
Post Comments (Atom)
Wow! I jumped into Numbers for the first time yesterday as a 10 year excel user. Didnt make it easy for myself, trying to work with a multi tab, charted excel monster, who data I needed to transpose to work on. Alas, I couldnt find how to do this, and yet, yours is the first item I find on the web! Great stuff! Will let you know how I get on!
PS are there known bugs when using excel 2007 in numbers 09? Many of the formulae were broken, but it could well be user error!
Thanks!
Fiona I'm glad that you found this tutorial so helpful, and that you found it so easily.
As for bugs in Numbers '09 I'm really not sure of any, but I do know that that Numbers is geared more towards the everyday user and therefore doesn't have near as many functions and formulas as Excel. That is probably the problem you are running into. Hopefully the next version will have many more! I believe there were over 100 new functions and formulas from Numbers '08 to '09.
Thank you for posting this (nearly two years ago). I am working on a project with survey results, and although I was looking forward to Numbers' fancy data compilation features, I could use none of it until I transposed the table. We can only hope that transpose will be as easy as a click when the next generation of Numbers arrives.
THANK YOU! You just saved me SO much time with this. Numbers has a lot of fancy bells and whistles but sometimes Excel wins. Your tutorial was very concise and easy to follow, even someone without background in formula writing would be able to follow. Thank you again