Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have text data (name, address, city, state, zip) that has been entered on a
spreadsheet in columns down the spread sheet (each criteria in it's own cell vertically/in columns) and I need each of the above mentioned criteria to be in it's own cell horizontally so that it can be imported into a database. so in other words the name, address etc woul read from left to right across the spreadsheet. I have Mircosfot Excel 2003. I have over 300 names and addresses to convert. Any idea on how to make this fast and easy would be very appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) | |||
how do i hide value errors until data can be entered? | Excel Worksheet Functions | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
How do I change how PivotChart data is summarized, from sum to av. | Excel Worksheet Functions | |||
VBA: Looked up data / now how do I change it? | Excel Worksheet Functions |