Rotate row

[MattG]

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?

[Ragdyer]

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>.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MattG" <[email protected]> wrote in message
news:[email protected]...
> 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?

[MattG]

Ragdyer wrote:

> 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>.

Thanks, much appreciated

[Gord Dibben]

Matt

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


Gord Dibben MS Excel MVP

On 18 Jun 2006 15:01:21 GMT, "MattG" <[email protected]> wrote:

>Ragdyer wrote:
>
>> 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>.
>
>Thanks, much appreciated