Swapping rows and columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey guys,

Is there a quick way to make the spreadsheet rotate so all of the rows are
columns and all of the columns are rows? There aren't any formulas on the
sheet so references shouldn't be a problem.
 
Try selecting the cells to rotate, then ctrl+c.
Goto Edit-Paste Special.
Select Transpose.

Regards,
Paul
 
Select the data in the worksheet and click the copy button
Move down to an used part of the worksheet; right click in a cell in column
A and select Parte Special from the popup menu; click in the Transpose box,
click OK
Now delete the original data
best wishes
 
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

Excel Help to copy information from one row at a time to another sheet 1
Match and delete rows on two different sheets from reference numbers 4
Index Match on Columns and Rows 0
Compare identifier columns from 2 sheets - remove rows that are dups 2
using the =page! feature to transpose a row to column 0
Hide columns based on row values 2
How to swap the contents rows and columns in a spreadsheet? 2
COPY RIGHT AND TRANSPOSE 2

Back
Top