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.
How do you transpose row and columns. I have tried selecting the table and clicking on the table option on the menu. But the transpose row and column was greyed out. I have tried everything I can to select the table and yet the transpose row and column option remained greyed out. Help
I am on numbers version 11.2
[Re-Titled by Moderator]
Got it. Just solved it. It appears that the location of the document was the problem. When moved to a local directory, the transpose option was then available. Thanks. The problem is solved.
swillia749
Got it. Just solved it. It appears that the location of the document was the problem. When moved to a local directory, the transpose option was then available. Thanks. The problem is solved.
swillia749
Unless you have locked the table (via the menu Arrange > Lock or the keyboard shortcut command-L) you should be able to click in any of its cells and choose Table > Transpose Rows and Columns from the menu.
Unrelated to your transpose problem, but good Numbers usage: define the row where you have sums for the columns as a Footer Row. Then you can just use SUM(B), SUM(C), etc. rather than cell ranges and you can add rows to the table without having to adjust the formulas.
SG
NOTE TO SGIII
HI SG
OFF TOPIC for this question.
Your scripting talents are needed for this thread in the Pages for Mac community.
https://discussions.apple.com/thread/253568213
Please take a look.
Regards,
Barry
(Apologies to Swillia for dropping into your message space. Good to see you've solved your issue.)
B
Could you post a screenshot of your table? shift-command-4, use cross-hairs to select area on screen, release, then start a new post here and insert the screenshot image from the Desktop using the "mountains and moon" icon at the bottom of the compose window.
SG
Thanks for your response SG. It has been very useful especially the summation of cell ranges.
I have checked if my table was locked and it was not. What i would have loved to attached the data in numbers to this reply, but the system does not allow me to do so. You may be able to pick something that I have not seen. I still have a greyed transpose option. I may have to go to apple direct as the problem is still there. But thanks for you help and support. Much appreciated.
Any other advice that you may wish to give would be gratefully welcomed.
swillia749
swillia749 wrote:
What i would have loved to attached the data in numbers to this reply, but the system does not allow me to do so
If you don't have any personal or confidential data in the document and you store it in iCloud Drive then you can "share" it and paste the link in a post here. In the menu: Share > Collaborate with others ... Copy Link and choose 'Anyone with the link' under 'Who can access:' Or if you have a Dropbox account you can Copy Dropbox Link and paste that in a post.
SG
thank you for that solution. I would never have thought of that. It doesn't make sense to me what difference it makes whether you're saving on your computer or icloud?? I have almost all my files automatically saved to icloud. The workaround was I copied the table from the cloud to my local computer, transposed it, and then copied and pasted back to the cloud.
Same general idea. I've read about people having unexpected behavior in shared documents or documents in which they collaborating with other people. The solution was to turn off sharing or collaboration temporarily, make the change, and then turn it back on. That may apply in this case too.
SG
Hi SG
I have attached a pdf version of the screen shot. If that is ok. I can provide the numbers file if it will help.
Swillia749
May have something to do with whether the document is "shared" when it is stored in iCloud.
SG
SG, How do you tell if a document is "shared"? Is that the same thing as collaboration?
How do you transpose row and columns in Numbers?
