Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
New row after every comma ","
Hi...
Ive got a small problem that i just cant get working good. Ive got a workbook with about 15 columns and 1000 rows. In column D there are numbers seperated with a comma. Here is an example of my sheet: A B C D test1 red 50 3,5,23,67,56,23,4 test2 blue 60 5,6,87,54,98 test3 orange 40 7,87,52,16 etc.etc The numbers in column D are refering to other rows (predecessors in projects). What i want is to insert an extra row for every number. My output will look like this: A B C D test1 red 50 3 5 23 67 56 23 4 test2 blue 60 5 6 87 54 98 test3 orange 40 7 87 52 16 etcetc. Can anybody help me out with this.... thanks in advance!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV dropping last comma for all lines after line 15 | Setting up and Configuration of Excel | |||
Comma Deliminated File Format | Excel Discussion (Misc queries) | |||
Applying Indian comma style | Excel Discussion (Misc queries) | |||
Comma is not visible in Excel | Excel Discussion (Misc queries) | |||
HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) |