Assign list based on column value

[Cr864]

Hi, i was wondering if someone could guide me on the quickest way to post the list of names below based on the number on the column beside it. We'll just call them column A & B for the purposes of this and the destination column could be column C. We have work assignments we sign out each day and each number is the number of work assignments they should get out of a greater list.

The way we currently do it is just copying all the names, pasting 5 times, copying all the names except the 5s, pasting 5 more times to get to the 10s, etc etc until everyone gets their amount. Surely there is a quicker way

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C
1
2	A	2	A
3	B	0	A
4	C	5	C
5	D	3	C
6	E	2	C
7	F	2	C
8	G	3	C
9	H	5	D
10	I	1	D
11			D
12			E
13			E
14			F
15			F
16			G
17			G
18			G
19			H
20			H
21			H
22			H
23			H
24			I
25
Main

Cell Formulas
Range	Formula
C2:C24	C2	=LET(a,TEXTJOIN("",,REPT("</m><m>"&A2:A10,B2:B10)),FILTERXML("<k><m>"&MID(a,8,LEN(a))&"</m></k>","//m"))
Dynamic array formulas.

 

[Cr864]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C
1
2	A	2	A
3	B	0	A
4	C	5	C
5	D	3	C
6	E	2	C
7	F	2	C
8	G	3	C
9	H	5	D
10	I	1	D
11			D
12			E
13			E
14			F
15			F
16			G
17			G
18			G
19			H
20			H
21			H
22			H
23			H
24			I
25
Main

Cell Formulas
Range	Formula
C2:C24	C2	=LET(a,TEXTJOIN("",,REPT("</m><m>"&A2:A10,B2:B10)),FILTERXML("<k><m>"&MID(a,8,LEN(a))&"</m></k>","//m"))
Dynamic array formulas.

This works perfectly! Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.