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

 

[MattG]

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