Rotate row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MattG - 18 Jun 2006 14:31 GMT

Hi all,

A friend has a huge workbook that her tutor has entered lots and lots
of data into. She intends to use this data for her college project, but
it's been entered across the book and she'd really like to turn all the
rows into columns.

Any way to do this? All at once or one by one?

Reply to this Message

Ragdyer - 18 Jun 2006 14:44 GMT

You can do it all at once as long as you have enough room on the sheet,
where the new configuration will *not overlap* the old configuration.

Select the rows and right click in the selection and choose "Copy".

Right click in the top left cell of the new location (remember - no
overlap), and choose "PasteSpecial",
Click "Transpose", then <OK>.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Hi all,
>
[quoted text clipped - 4 lines]
>
> Any way to do this? All at once or one by one?

Reply to this Message

MattG - 18 Jun 2006 16:01 GMT

> You can do it all at once as long as you have enough room on the
> sheet, where the new configuration will *not overlap* the old
[quoted text clipped - 5 lines]
> overlap), and choose "PasteSpecial",
> Click "Transpose", then <OK>.

Thanks, much appreciated

Reply to this Message

Gord Dibben - 18 Jun 2006 16:08 GMT

Matt

If not room on the original sheet, you can copy/transpose to a new sheet.

Gord Dibben MS Excel MVP

>> You can do it all at once as long as you have enough room on the
>> sheet, where the new configuration will *not overlap* the old
[quoted text clipped - 7 lines]
>
>Thanks, much appreciated

Reply to this Message