| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create rows from existing rows
I have a spreadsheet in the format listed below. I would like to spreadsheet each number separated by semi colons into a new records. Please help me with excel VBA code to complete this task. Thanks, Column A Column B Column C Colorado 1;4;6;11;25 Denver Florida 24;38;44;12 Miami Illinois 13;7;8;9;10 Chicago Desire Output Column A Column B Column C Colorado 1 Denver Colorado 4 Denver Colorado 6 Denver Colorado 11 Denver Colorado 25 Denver Florida 24 Miami Florida 38 Miami Florida 44 Miami Florida 12 Miami Illinois 13 Chicago Illinois 7 Chicago Illinois 8 Chicago Illinois 9 Chicago Illinois 10 Chicago |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add many rows in between existing rows in spreadsheet? | Excel Worksheet Functions | |||
| New rows overwriting existing problem | Excel Programming | |||
| How to find the rows existing in one column but not the other? | Excel Programming | |||
| Insert Rows between the existing rows | Excel Discussion (Misc queries) | |||
| inserting a row between two existing rows | New Users to Excel | |||
Threaded Mode
