How do I transpose data in worksheet?

R

Roberto

I have a worksheet with data and want to transpose it from
displaying the column headers across columns to display
across rows.

How can this be done?

Thanks,
Roberto
 
D

Dan E

Select the range,
Copy
Paste Special and check off transpose

you may wan't to paste it on a new sheet
so it doesn't overwrite anything.

Dan E
 

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

Copy addition formula of non-consecutive horizontal cells 2
Eliminate blanks while copy row and transpose 11
Copying formulas in Columns and transpose to rows? 5
TRANSPOSE results in zero values for blank cells 2
Rearranging Data 0
Need transpose? help.... 9
Is there a way to do a "lookup" and change the orientation of the 6
XL2007: I need a sumproduct formula that will transpose as I copyacross columns 2

Top