​​ ​

The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.


You can continue to find trusted guidance and support on the official Apple Support site. 


We want to thank the community members who have contributed their time and expertise to help others with their Apple products.


transpose columns and rows in numbers

I need to transpose columns and rows in Numbers and I do not want to write script to do it. Is there an easier way?

MacBook Pro, iOS 6.1.4, iWork - Numbers

Posted on Jul 29, 2013 11:10 AM

Question marked as Top-ranking reply

Posted on Dec 15, 2017 11:20 AM

Just select the table you want to transpose and click on the menu bar item: "Table > Transpose Rows and Columns"


User uploaded file

97 replies

Feb 1, 2014 4:57 PM in response to Eltham Jones

I've tried every solution that's been posted on every board and this is the only one which has worked consistently and without undue fuss and complication.


Glad it's working there. It's also solved the problem for me. I like simple with no fuss too, especially when I have such a limited repertoire. The pros who look at it will see the signs of an amateur. But it works. And I figure that's what AppleScript (and indeed Numbers) are for: they put a lot of computing power into the hands of non techies.


@Jerry, thanks for the link to Ivan's script. It finally came alive for me today. (Maybe a new month and a new bandwidth quota?) Anyway, I'll see if I can follow along (it looks complicated!) and maybe update it to work with Numbers 3.


SG

Feb 2, 2014 11:39 AM in response to Barry

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


Yes, Larry🙂. My apologies to Yvan, though. I hope my mental lapse hasn't detracted from his contributions to the Numbers user community. I'm sensitive about names myself, being (apparently) the only living person on the planet with my particular combination of just four common English syllables. The problem is that they could easily form two first names or two last names. Most decide the first must be the last. Or the last must be the first. Some throw in a tiny spelling "correction" to confirm whatever bias they may have toward the natural order. Anyway, I'll watch my i grec.


SG

Feb 2, 2014 1:45 PM in response to SGIII

"being (apparently) the only living person on the planet with my particular combination of just four common English syllables"


That's nothing; you should try carrying around the name of a suburb of London, and one that has the unenviable reputation of being the most racist... 😉


http://www.independent.co.uk/news/uk/crime/two-decades-have-passed-but-the-hate- goes-on-in-eltham-6285108.html

Mar 6, 2014 7:29 AM in response to hplovejet

Hi Tom,


Nice to see the demo of what I call the 'Copy Transpose' script in action! You may have noticed you can share it as a "self-installing" service by choosing the .workflow package in Finder, right-clicking, and and choosing Compress.... The recipient just has to double-click the .zip package and it will move itself to the Library > Services folder so that it appears in the Services menu. (The recipient may have to click 'download anyway' in System Preferences > Privacy & Security).


SG

Mar 7, 2014 2:23 AM in response to SGIII

Awesome 🙂 I wish I knew others who share this problem so I could send this to them, but assume the Numbers "community" would be delighted to be able to simply download such a service. I assume this forum doesn't permit hosting such files, but I would be happy to do so unless anyone can suggest a better alternative.


I think I forgot to thank you for sharing this, so thanks very much!

Tom

Apr 18, 2014 9:57 AM in response to diegoumich

One other thought. If you're using Numbers 2 and not Numbers 3, then the script should work if you replace this line:


tellapplication "Numbers" totellfrontdocumenttotellactive sheet


With this:


tell application "Numbers" to tell front document to tell (first sheet whose every table's selection range's class contains range)


SG

May 20, 2014 11:27 AM in response to SGIII

Hi SGIII,


I think I'm missing something on this. I'm using Numbers 3.2 but everytime I select a range and then select the workflow I get an error message saying:


"Select a range first and then try again"


Is there something special I need to do when selecting a range ?


Hope you can help


Thanks in advance


Natalie

May 20, 2014 12:04 PM in response to Community User

Ok I solved it, well it's working now anyway !!


For some bizarre reason after I had quit numbers and re-opened the same file it is all now working, so thank you again SGIII your workflow has saved me from lots of tedious data entry.


Thanks

May 20, 2014 1:02 PM in response to Community User

Hi Natalie,


Great to hear it's working now! One thing that's easy to forget is that only one version of Numbers should be open at the time you run the script. Also some utility-type applications that jazz up your clipboard (CopyClip, Command-C, CommandClip, and probably dozens or hundreds of others) can get in the way.


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

transpose columns and rows in numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.