View Single Post
  #1   Report Post  
Adam@Penda
 
Posts: n/a
Default Can I convert columns to rows?

I need to convert address information, which is on word and listed
vertically, to an excel spreadsheet, and have the information list out
horizontally. Is this possible to do? I am familiar with the basics of each
program, but using "range,formula,value" options in excel confuses me.
Here's an example:

(My data in word)

Mel's Tire Store, Inc.
300 Culbertson Avenue
Worland, WY 82401
(307) 347-3601

Need to copy and paste so data spreads horizontally in Excel, under these
colum headings:

"Business Name" "Address" "City" "State" "Zip"
" Phone"
Mel's Tire Store, Inc. 300 Culbertson Worland WY 82401
(307)347-3601

Is this possible or do you know a way I could make something like this
happen? Thanks for your time and imput!