You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
CD,
There is a TRANSPOSE function, but it's not too useful in my experience, since you have to use INDEX to read the result out of internal memory. Below are two examples, the first using TRANSPOSE and INDEX and the second using only INDEX, but this time reading the input table directly rather than via the transpose function. Note that skipping the transpose function requires that you reverse the Row and Column arguments.
In case the graphic is difficult to read, the first expression is:
=INDEX(TRANSPOSE(INDIRECT("Input")), ROW(), COLUMN())
and the second expression is:
=INDEX(Input, COLUMN(), ROW()).
Jerry
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.
beckminsterfullerene wrote:
(Also BTW I tried to do that "services" thing to add the function to Numbers, but it didnt work.)
Well, that "service" thing worked well while it was needed. But this is a REALLY old thread. In Numbers 3 it's just a simple menu pick.
SG
"Here's the easiest way yet - just do it on a google spreadsheet."
How is copying, pasting special to a Google spreadsheet, copying again from there and pasting into Numbers easier than the procedure below, posted by SG March 3rd, is response to Duncan Parks?
"In the current version of Numbers all you have to do is click in the table and choose 'Transpose Rows and Columns' from the Table menu.
SG"
EDIT: ...and repeated immediately above.
Regards,
Barry
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
Oh, have they finally fixed it? I gave up on Numbers in 2014. 😝
Transpose Rows and Columns was added years ago.
SG
transpose columns and rows in numbers
