Convert columns to rows in Excel Mac

unread,

Apr 5, 2010, 2:55:16 PM4/5/10



Sign in to reply to author

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I can't find any instructions for formatting rows to columns for the Mac 2008 version. When I searched help for the same instructions for my PC version on my work computer, they were straightforward and easy to execute. How do you switch columns to rows and vice versa in the Mac 2008 verson of Excel? I'm running a Mac Mini.

unread,

Apr 5, 2010, 8:42:38 PM4/5/10



Sign in to reply to author

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

There's no question that the Help in Office 2008 leaves a lot to be desired,but what you're asking about works no differently in the Mac version. Oneoption is to use the Transpose() function, although I get the impression

that you're looking for the Transpose option in Paste Special. In that case;

Select & copy the data you want to transpose,

Select the cell you want the transposed data to start in,

Go to Edit> Paste Special, tick the Transpose checkbox, then click OK.

HTH |:>) Bob Jones

[MVP] Office:Mac

unread,

Apr 13, 2010, 12:43:34 AM4/13/10



Sign in to reply to author

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

I have MicroSoft Excel 2008, Version 12.2.4 and am trying to convert columns to rows. Paste Special in my version (under Edit in the drop down menu) allows only two options: paste: Unicode text Text

There is no Transpose option.

unread,

Apr 13, 2010, 8:59:01 AM4/13/10



Sign in to reply to author

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

Paste Special offerings vary depending on what was copied & from where thecopying was done. If you get that flavor of the options it most likely means

that what you have copied is not Excel content.

HTH |:>) Bob Jones

[MVP] Office:Mac

On 4/12/10 10:43 AM, in article ,

unread,

Apr 13, 2010, 10:29:46 AM4/13/10



Sign in to reply to author

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

That means that what you copied is a string of text. It is not Excel"cells". Excel can't transpose anything that is not already a column of

cells.

On 13/04/10 12:43 AM, in article ,

"" <> wrote:

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,McGhie Information Engineering Pty Ltd

Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:

unread,

Apr 27, 2010, 8:02:48 AM4/27/10



Sign in to reply to author

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

I have the same issue. Transpose is not an option and the information I am trying to transpose is in the same spreadsheet so it is in the correct format. Any other options?

unread,

Apr 27, 2010, 5:35:14 PM4/27/10



Sign in to reply to author

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message