Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to conditionally duplicate rows
Hi,
Not sure if this is the correct group or not. I need to massage an Excel spreadsheet. Specifically, if a cell in a column contains more than one element (separated by commas) then I need to duplicate that row with one element in each row. For example, I want to convert this: Stuff1 an element Stuff2 one element, two element Stuff3 another element into this: Stuff1 an element Stuff2 one element Stuff2 two element Stuff3 another element where "Stuff1" is in column 1, and "an element" is in column 2. Any ideas how I can do this? I can program in more languages than I care to remember, but have never used Visual Basic. Would Visual Basic be able to do this, and where might I find an example of something similar. The spreadsheet has thousands of rows with hundreds of rows which need to be duplicated. Doing it by hand would therefore be a last resort. Many thanks for any help you can give. -- Regards, Martin Leese E-mail: LID Web: http://members.tripod.com/martin_leese/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally put rows at the top of each page? | Excel Programming | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
conditionally join rows | Excel Discussion (Misc queries) | |||
Conditionally formatting rows | Excel Worksheet Functions | |||
Hidind rows conditionally | Excel Programming |