Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Increment columns in rows | Excel Discussion (Misc queries) | |||
The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
Removing unused or blank rows and columns | Excel Discussion (Misc queries) | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) |