How do I transpose data in worksheet?

  • Thread starter Thread starter Roberto
  • Start date Start date
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
 
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

Copying formulas in Columns and transpose to rows? 5
TRANSPOSE results in zero values for blank cells 2
TRANSPOSE results in zero values for blank cells 4
Is there a way to do a "lookup" and change the orientation of the 6
LINEST multiple known_x's separated arrays 5
Need transpose? help.... 9
Linking cells between worksheet - from column to row 2
Reverse Transpose? 4

Back
Top