Changing Rows to Columns

  • Thread starter Thread starter hlc
  • Start date Start date
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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Flipping data - columns to rows and visa versa 2
How to sort entire spreadsheet by one column sort 5
EXCEL SORT 3
what row do I start an address for a window envelope? 1
How to filter rows data based on background color of individual cells 1
Sort / Copy Macro 2
sort multiple columns 5
Column and Row mapping? 4

Back
Top