row to column

[fmarti]

Is it possible to convert 3 rows in Excel into 3 columns? Or a row at a time?

I am running 'Excel for Mac V12.2.3' on OSX 10.6.2.
Thanks,
Felix

[teylyn]

Hi Felix,

welcome to the forum. Unless you're absolutely dying for more spam in your mailbox, you shouldn't post your email address. You can still edit your post to remove it.

You can use the Transpose option in the Paste Special dialog to paste a column as a row and vice versa. You can select a whole table, consisting of several columns and rows and using Paste Special - Transpose, flip the whole thing sideways, so to speak.

hth