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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Transpose not working

I am using Numbers version 6.2.1 (6529)


My table is selected but the Transpose is not working. It is greyed out, however, my cells are not merged, hidden or locked.

MacBook Pro 15", macOS 10.14

Posted on Nov 24, 2019 2:38 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 24, 2019 6:29 PM

have many rows are you trying to transpose? Numbers can only support 255 columns. So if the number of rows you have (before you transpose) exceeds 255, then transpose.


I should note... that I just checked and can confirm that transpose is unavailable even when it should be. You can post feedback regarding a bug using the Numbers menu item "Numbers > Provide Numbers Feedback" you should post a link of the this thread in your feedback.



6 replies
Question marked as Top-ranking reply

Nov 24, 2019 6:29 PM in response to KATIE_GRIFFIN89

have many rows are you trying to transpose? Numbers can only support 255 columns. So if the number of rows you have (before you transpose) exceeds 255, then transpose.


I should note... that I just checked and can confirm that transpose is unavailable even when it should be. You can post feedback regarding a bug using the Numbers menu item "Numbers > Provide Numbers Feedback" you should post a link of the this thread in your feedback.



Nov 24, 2019 6:48 PM in response to Wayne Contello

I was able to transpose a table on a local document (not one stored in iCloud). The document it did NOT work on was one that was shared and stored in iCloud.


If you need to transpose a table in a shared document, copy the table, paste into a new document, perform the trasnposition, then copy and paste the table back to the shared doc.

Nov 25, 2019 8:08 AM in response to Wayne Contello

I have never used the feature before so I do not know what it used to do. What I see is that it transposes the entire table, not a selected area. This is also how it is described in the "help". If the table has more than 255 rows, even if they are blank, it will not transpose the table.


Wayne, your screenshot cuts off at row 24. How many rows were in that table table you tested?

Transpose not working

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