Dynamic List from Table

[TheRogue]

I have a table which lists types of soda & the quantities on hand.
I'm trying to create a dynamic list that would put each one on a new row (skipping zero quantities). It would list each, the # of time specified & then move on to the next value. The result list for this table should look something like:
COLA
COLA
COLA
GRAPE
GRAPE
CHERRY
CHERRY
CHERRY
GINGER ALE
ORANGE
ORANGE

<colgroup><col style="mso-width-source:userset;mso-width-alt:2413;width:50pt" width="66"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> </colgroup><tbody>
[TD="width: 66, align: left"]COUNT[/TD]
[TD="width: 79, align: left"]ITEM[/TD]

[TD="class: xl65"]3[/TD]
[TD="align: left"]COLA[/TD]

[TD="class: xl65"]2[/TD]
[TD="align: left"]GRAPE
[/TD]

[TD="class: xl65"]3[/TD]
[TD="align: left"]CHERRY[/TD]

[TD="class: xl65"]0[/TD]
[TD="align: left"]DIET[/TD]

[TD="class: xl65"]1[/TD]
[TD="align: left"]GINGER ALE[/TD]

[TD="class: xl65"]2[/TD]
[TD="align: left"]ORANGE[/TD]

[TD="class: xl65"]0[/TD]
[TD="align: left"]LEMON
[/TD]

</tbody>

 

[Peter_SSs]

Peter - Thank you for your response. The Data in columns B&C are my starting point (that's the data provided), Column A is the result that I'm trying to achieve. However, I need to do it in a way that is dynamic (so that if one of the quantities in column B are changed, the List in column A automatically adds or removes entries, as appropriate.

Sorry, I had misread the question.

Would a helper column (could be hidden) be acceptable?

C1 is a stand-alone formula
C2 copied down to the end of your data.
B11 copied down as far as you might ever need.

Excel Workbook
	A	B	C
1	COUNT	ITEM	11
2	3	COLA	1
3	2	GRAPE	4
4	3	CHERRY	6
5	0	DIET
6	1	GINGER ALE	9
7	2	ORANGE	10
8	0	LEMON
9
10
11		COLA
12		COLA
13		COLA
14		GRAPE
15		GRAPE
16		CHERRY
17		CHERRY
18		CHERRY
19		GINGER ALE
20		ORANGE
21		ORANGE
22
23
List

 

[TheRogue]

Yes. Thank you. This does exactly what I want it to. Now, I just have to see if I can "tweak" it some. (The provided data is a table. There is no problem w/ adding a helper column to the table, but the result has to live elsewhere.) You've showed me the concept (which I now understand), now I just have to apply it to my situation.

 

[Peter_SSs]

Now, I just have to see if I can "tweak" it some. (The provided data is a table. There is no problem w/ adding a helper column to the table, ...

Try something like this

Excel Workbook
	A	B	C	D	E	F
1	COUNT	ITEM	Helper			List
2	3	COLA	1			COLA
3	2	GRAPE	4			COLA
4	3	CHERRY	6			COLA
5	0	DIET				GRAPE
6	1	GINGER ALE	9			GRAPE
7	2	ORANGE	10			CHERRY
8	0	LEMON				CHERRY
9						CHERRY
10						GINGER ALE
11						ORANGE
12						ORANGE
13
List

 

[TheRogue]

Thank you very much! This is going to work perfectly.
As usual, I had gotten "lost in the weeds" & was over-complicating it.

 

[Peter_SSs]

No problem, glad to help.