| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows based on number of items
In Excel 2003
i have a list of items for which i would like to create individual rows based on the number of items. i.e. Below is the data Number Item 1 Apple 3 Orange 2 Banana Output would look like this Apple Orange Orange Orange Banana Banana |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show a number of rows based upon user input | Excel Discussion (Misc queries) | |||
| How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
| Deleting rows based on number of characters | Excel Discussion (Misc queries) | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
Linear Mode
