View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default How do I convert rows into columns?

"Rick" wrote in message
...
J C's Generator Starter & Alternator Co
1160 Providence Rd
Scranton, PA 18508
570-347-0861


A J's Auto Clinic
1430 Main Ave Ste Rear
Scranton, PA 18508
570-343-7828
AUTO REPAIR

Aamco Transmissions
1230 Keyser Ave
Scranton, PA 18504
570-969-1940
AUTO REPAIR


Copy the row, click the top cell of the desired column, then edit, paste
special and tick transpose.

V