iWork Numbers Transpose and a Food Survey
When I switched from using Microsoft Office to last semester, I too was when I couldn’t find a built-in transpose in Numbers, the spreadsheet program. But then I realized it’s not so bad, if you just use the index function.
For example, here are the food preferences of our household for a sample of foods.
I should do further calculations to figure out which two are the most similar. (=
The transpose cells all contain this: 
Not sure why people were writing complicated scripts for that. Maybe it was before the INDEX function?
Anyway, I still love iWork. It’s just so pretty, and it doesn’t hang on stuff randomly like Excel for Mac did (to be fair though, I only had Microsoft Office X, this was before , which might be better.) My only complaint - I would like a little more fine-grained control over the graphs/charts features; Apple does a good job making lovely defaults but they ought to let us tweak things a bit more. Hopefully it’s coming. I’ve also seen complaints about it being slow for larger spreadsheets, but I haven’t had any real problems so far. Except for sort. Optimizing that one clearly wasn’t a priority. It’s also missing the formulas views feature which was occasionally useful in Excel (cntrl-`). So I guess that’s 3 complaints. But all fairly minor.
January 26th, 2008 at 5:04 pm
Put this into Freebase NOW!
January 26th, 2008 at 6:59 pm
I’m shocked that Ben doesn’t like raw broc. Also, I find it interesting that there there are very few foods that anyone scored between 1-4.
January 26th, 2008 at 11:36 pm
yea, ben likes his broccoli a lot when it’s cooked a bit, but he won’t eat the raw. i noticed the 1-4 thing too — i guess we all just like food. (=
January 26th, 2008 at 11:36 pm
and we have tried a pellet just to be sure, they’re not tasty at all!
January 26th, 2008 at 11:47 pm
I suppose I could get used to raw broccoli. But I don’t like it right now. Blanched is fine tho.
January 28th, 2008 at 7:50 am
Unrelated, but I wanted to tell you one of my favorite things about Minnesota. As you know, we have A LOT of cottontails in this city, even in DT Mpls. Anyway, with the snow cover you can see what they’ve been up to the previous night and the past few days since the last snow — their trails are so cute!
January 28th, 2008 at 11:26 am
oooh ooh! can you get a picture? i want to see!
January 28th, 2008 at 7:07 pm
Yup, we’re supposed to get a new layer of snow tomorrow so it should be perfect!
April 27th, 2008 at 10:55 am
I just learned about the INDEX function from your post, and saved myself about 2 hours busywork. Thanks.
April 28th, 2008 at 12:58 pm
yay i’m glad! :)
May 6th, 2008 at 10:33 am
[…] I just found this great Numbers tip on Fury&Frost.com: […]
May 6th, 2008 at 10:35 am
Nice tip! I shared it on my Numbers blog today.
If you’re interested, you can find the post here:
April 3rd, 2009 at 10:43 am
Thanks a bunch! I was really struggling with the whole transpose thing (also coming from Excel). This has been a huge help.
May 28th, 2009 at 11:15 am
Mmmh, just got: syntax error?
=INDEX(Prefs :: $A$1:$D$6,COLUMN(),ROW())
September 16th, 2009 at 9:09 am
Much interesting, well why all exactly so?
November 14th, 2010 at 5:29 am
To view formulas in iWork 09 ( Numbers 09 )
GoTo View > Show Formulas List
Formulas are listed, but do not appear on the worksheet itself, but still helpful
Cheers !
January 18th, 2011 at 8:12 am
can i used this article to my new blog…tq
May 31st, 2011 at 8:50 am
Awesome- works like a charm
August 29th, 2011 at 2:13 pm
I have no real idea what I’m doing but combining a few ideas from other sites I made this modification which doesn’t put a zero in blank fields.
=IF(ISBLANK(INDEX(Table 1::$A$1:$F$46,COLUMN(),ROW())),”",(INDEX(Table 1::$A$1:$F$46,COLUMN(),ROW())))
August 29th, 2011 at 8:33 pm
autogate…
fury & frost » Blog Archive » iWork Numbers Transpose and a Food Survey…
December 14th, 2011 at 3:57 pm
pareti doccia…
[…]fury & frost » Blog Archive » iWork Numbers Transpose and a Food Survey[…]…
December 15th, 2011 at 9:17 am
I’m impressed, I must say. Actually not often do I encounter a blog that’s each educative and entertaining, and let me tell you, you could have hit the nail on the head. Your thought is excellent; the difficulty is one thing that not sufficient people are speaking intelligently about. I’m very completely happy that I stumbled throughout this in my seek for something referring to this.
December 15th, 2011 at 8:19 pm
I have been wanting to start a successful blog i want to start a blogg useing the best free blogg starting website …. pleez tell me which one is the best??????\.
December 16th, 2011 at 12:16 am
December 16th, 2011 at 1:54 pm
ps3 ylod…
[…]fury & frost » Blog Archive » iWork Numbers Transpose and a Food Survey[…]…
January 27th, 2012 at 4:48 pm
Motivational Blogs…
[…]fury & frost » Blog Archive » iWork Numbers Transpose and a Food Survey[…]…
March 13th, 2012 at 7:06 am
pellet…
[…]fury & frost » Blog Archive » iWork Numbers Transpose and a Food Survey[…]…
April 8th, 2012 at 3:21 am
I have learn a few excellent stuff here. Certainly worth bookmarking for revisiting. I surprise how much effort you set to create such a wonderful informative website.