| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel rows into columns
I have 37, 800 rows and 1 column. Column A is as follows:
A1 George Brown A2 1234 Street A3 Browntown, USA 00234 A4 blank A5 blank A6 blank A7 Betty Smith A8 2345 Avenue A9 Thistown, USA 00987 And the pattern repeats for the next 37,800 rows. I need to get 3 columns setup. A1: Name B1: Address C1: City, State Zip I have a little knowledge of VBA but on this one I don't know where to start. Any suggestions would be very appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Excel see columns as rows and rows as columns | Excel Discussion (Misc queries) | |||
| how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
Threaded Mode
