Changing Rows to Columns

H

hlc

Is it possible to easily rotate a spreadsheet or part of a
spreadshet, to change the data in rows to columns? Do to a
sorting problem in the charts I create, it seems I have to
sort the data in the spreadsheet first.

Any help would be appreciated.
 
J

jeff

Hi,

Sure is a way. select & copy your data. then select
the cell where you want to re-paste; right-click and
select paste special; in the dialog box check "transpose".
Ok.

jeff
 
G

Gord Dibben

hlc

Carlos has explained how to transpose rows to columns.

Note: there are only 256 columns so you are limited to that in transposing
your data.

Another note: you can sort from left to right if that would help.

Gord Dibben Excel MVP
 
Top