transpose columns and rows in numbers

Ah, the bit that's always hidden by the dock...

Sneaky, Thanks Jerry, my wishlist is sorted!

HI SG,

Yvan is quite sensitive about the spelling of his name, and isn't here to defend it. Please try to get it right.

Regards,

Barry

EJ,

"Sometimes you have to compromise!"

Understood. One does what one thinks is best.

Regards,

Barry

You can grab a copy of a self-installing 'Copy Transpose' Automator Service here (Dropbox download). Feel free to share as you see fit.

SG

That's perfect, thanks SGIII

Glad you were able to get it to work in Numbers 2.

SG

Dude, thanks, first time I use automator and this is the only way I could solve this... 😝 thumbs up!

Glad it worked. Thanks for the positive feedback!

SG

just out of curiosity, any idea why the variable assignment doesn't seem to work in Numbers 2 on mountain lion?

It compiled just fine and was finding the selection range and telling me what the range was (I added some display dialog lines to try to find where the error was occurring and used the name property to see if it was getting the selection and it could do "name of selection range" but not "name of my_selection" so I figured the assignment of selection range to my_selection wasn't working in Numbers 2/mountain lion. But it's an odd error since assignments should be pretty foolproof.

Not a big deal really since it works now.

I'm definitely in the "child" category by the way. I used http://macosxautomation.com/applescript/iwork/numbers/range.html to give me a little bit of a clue but I don't actually know what I'm doing.

Thanks again.

(sorry, I'm Thor Klamet2 now, it made me create another account for some reason to use the support forum again, no idea why, same person as before though)

That is marvellous. Thanks very much for saving me hours of work🙂

Great to hear it is helping others. Thanks for the feedback!

SG

Hi SG,

Now that you are on Level 5 (Bravo! for all that work helping others) how about posting a User Tip "The easy way to AppleScript" 🙂.

Regards,

Ian.

Well, after all these years -- yay.

THANK YOU!!!!*10 That works beautifully. May the universe shine on you for your generous donation of knowledge.

Thanks for a great fix! I was transposing a 130x130 matrix...so it saved a heck of a lot of time...