transpose function

[johnT]

I'm trying to convert a wertical list of data in a column
to a horizontal listing along a row using the transpose
function but I can't seem to get it to work. Anybody have
any ideas???

 

[Chip Pearson]

John,

First select the cells in which you want to transposed data to
appear. Then type =TRANSPOSE(A1:A10) where A1:A10 is the range
of the data to be transposed, and press Ctrl+Shift+Enter rather
than just Enter. If you do this correctly, Excel will display the
formulas enclosed in curly braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Alan Beban]

Post what you've tried.

Alan Beban