I have data in a table. The first column is the item and the second column indicates how many rows I'd like to fill the data down as indicated below.
Item / Fill_Rows
A / 3
B / 2
A / 3
C / 4
I'd like to put a formula in the "Item" column that can be dragged down to produce the following output.
Item
A
A
A
B
B
A
A
A
C
C
C
C
The formula would need to reference the "Fill_Rows" column in the first table to determine how many rows of the "Item" to fill down.
Thanks!
Bookmarks