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
Thanks. Very elegant little script which works perfectly.
I did everything, but I keep getting this error. What did I do wrong?
Select a range first and then try again
Can't believe I didn't see this sooner (your reply to Duncan). Super easy. Just didn't read everything like I should've. Thanks SG
Glad you got it sorted out.
SG
WARNING: When pasting back in to numbers, apparently it can only handle a hundred or so columns at a time. So I had to do this piecewise. Make sure all your data is there.
Sweet! Worked great. Thank you for this :-)
Hi jalbe,
This thread is really old. Suggest you start a new thread, stating your question and the version of Numbers you are using.
SG
transpose columns and rows in numbers