In Excel, how do I change the rows into columns?

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

Guest

Current spreadsheet

a b c
l m n
x y z

Desired spreadsheet

a l x
b m y
c n z
 
Copy the cells, move somewhere else on the sheet or to another sheet, select
Paste Special | Transpose

regards

Trevor
 
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

Scrabble Value calculation for Welsh words 0
compile data base on hit 9
transpose rows to column (cell) 3
Lookup in a matrix (with x and y headings) based on value x and y 2
% of subtotal in pivot table 1
Append multiple columns 2
append multiple columns 2
Updating a file by another file 3

Back
Top