Populate column C with repeated entries based on count for each row in column A?

[kznmrexcel]

I have a worksheet that shows book copies for 921 A, B, C, etc. I need to create a list for merging out labels with the correct number of labels for each letter as entered. Example:

count	921 list
1​	921_A
7​	921_B
2​	921_C

According to this inventory sheet, I need
one label that is 921_A,
7 labels that are 921_B and
2 labels that are 921_C.

I would like a new column, "labels," (column C) that populates with:
921_A
921_B
921_B
921_B
921_B
921_B
921_B
921_B
921_C
921_C
....so I'm ready to merge out to the labels document.

If the "count" column is Column A,
"921 list" is column B, and
"labels" is to be in column C (one line item for each needed label),
is there a formula to populate column C based on the quantities entered in "count" column A for each line item in column B?

I appreciate any help with this.

 

[kznmrexcel]

Oof, just saw that I misnamed this thread with "Populate column D" when it should read "Populate column C." My apologies.

 

[Peter_SSs]

Oof, just saw that I misnamed this thread with "Populate column D" when it should read "Populate column C." My apologies.

I have changed it for you.

 

[Peter_SSs]

If you are still using Excel 2016 I would use a helper column (which could be hidden once the formulas are added)
Could you use something like this?

24 03 09.xlsm
	A	B	C	D
1	count	921 list	Labels	Helper
2	1	921_A	921_A	1
3	7	921_B	921_B	2
4	2	921_C	921_B	9
5			921_B	11
6			921_B	11
7			921_B	11
8			921_B	11
9			921_B	11
10			921_C	11
11			921_C	11
12				11
13				11
Labels

Cell Formulas
Range	Formula
C2:C13	C2	=INDEX(B:B,MATCH(ROWS(C$2:C2),D:D))&""
D2:D13	D2	=SUM(A$1:A1)+1