transpose function

  • Thread starter Thread starter johnT
  • Start date Start date
J

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???
 
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
 
Back
Top