| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicating Rows Based on Cell Value
I can't figure out to program this, please help!
I have rows of data like this: Name | Quantity | Attribute 1 | Attribute 2 EX1 | 2 | att1 | att2 EX2 | 3 | att1 | att2 EX3 | 2 | att1 | att2 I want it to expand the quantities into rows to look like this: Name | attribute 1 | attribute 2 | etc EX1 | att1 | att2 EX1 | att1 | att2 EX2 | att1 | att2 EX2 | att1 | att2 EX2 | att1 | att2 EX3 | att1 | att2 EX3 | att1 | att2 The Attribute 1 column and Attribute 2 column are just columns that hold data that needs to be copied to each row. This is to make a mail merge with multiple labels with the same information! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting rows based on cell entries | Excel Worksheet Functions | |||
| Add Rows based on Cell contents | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| generate multiple rows based on cell value | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
