ExcelBanter - Rows based on number of items

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rows based on number of items (https://www.excelbanter.com/excel-discussion-misc-queries/216325-rows-based-number-items.html)

jack

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

All times are GMT +1. The time now is 02:35 AM.