Thread: How do I take a column of data and put it in a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default How do I take a column of data and put it in a row
Select your data,
EditCopy
Select destination cell
EditPaste special, check Transpose

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"USJT" wrote in message ...
| Name
| Address
| City
| State
| ZIp
| email
| and make it look like
|
| Name Address City State Zip Email


Reply With QuoteReply With Quote