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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - In Excel, how do I change the rows into columns? (https://www.excelbanter.com/excel-discussion-misc-queries/11969-excel-how-do-i-change-rows-into-columns.html)

Novice SS User

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

Current spreadsheet

a b c
l m n
x y z

Desired spreadsheet

a l x
b m y
c n z

Trevor Shuttleworth

Copy the cells, move somewhere else on the sheet or to another sheet, select
Paste Special | Transpose

regards

Trevor

"Novice SS User" <Novice SS wrote in message
...
Current spreadsheet

a b c
l m n
x y z

Desired spreadsheet

a l x
b m y
c n z

All times are GMT +1. The time now is 09:50 PM.