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
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.
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.
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
I know... Normally it is hidden but if I have a lot of background apps running, on my older machine there is a lot of latency and the dock can be "sticky" so I leave it out. Sometimes you have to compromise!
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
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
"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
carrying around the name of a suburb of London, and one that has the unenviable reputation of being the most racist... 😉
Sounds like an unhappy place these days. But a fine old name. Tell 'em it's Eltham as in John of Eltham, or the Eltham ordinances, not that Eltham.
SG
Thanks SGIII
Can't believe how well that works.
Took me a while to work out you select origin text before services, then it works like a dream, so much so I created my first screencast - without sound I'm afraid 😟 http://youtu.be/A9spe0-Z1Wg
Tom
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
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
Hi SGIII,
Please I need your help, I have tried to run the script but I get the following message:
"Syntax Error
Expected end of line but found class name."
And "sheet" at the end of the second line of the script is highlighted. Could you help me figure out what is going on?
Thanks in advance,
Diego
Hi Diego,
Make sure you are running Numbers 3 without Numbers 2 open at the same time.
If you still get an error then try copying and pasting the script into AppleScript Editor.
Or you could try using the service you can download via the link upthread.
SG
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
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
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
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
transpose columns and rows in numbers