Rotate row

M

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?
 
R

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

MattG

Ragdyer said:
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>.
Click to expand...

Thanks, much appreciated
 
G

Gord Dibben

Matt

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


Gord Dibben MS Excel MVP
 
Top