| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i convert vertical data into horizontal data
I am not sure that this can be done but I am scanning a list of people,
address, city state and zip I can get it into excel but haven't figured out how to get into a format that will allow me to import it into a database. The data looks like this in the spreadsheet. Name first name other name Company Address (streee city st zip) Phone other info even more info I will have about 4000 names to deal with so some method of transposing all of this would be a real help. Even some suggestions as to software that will help would great. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn vertical data to horizontal data automaticaly | Excel Worksheet Functions | |||
| Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
| transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
| How to make Horizontal data go Vertical | Excel Worksheet Functions | |||
| tranfere vertical data to horizontal tabel | Excel Worksheet Functions | |||
Threaded Mode
