When I switched from using Microsoft Office to iWork last semester, I too was disappointed 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 Microsoft Office 2008 for Mac, 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.
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!
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.