Looking for a way to duplicate rows based on different numbers

[Sarah1989]

Hi, I hope I can explain this how it best makes sense.

The animal rescue I work at runs a raffle and our payment processor exports these payment to excel. I need to duplicate each row based on how many entries they have.

For example if someone has paid £10 we need to duplicate their row 9 times so they will have 10 entries. If someone has paid £3 we need to duplicate it twice so they have 3 entries etc.

Is there a way I can get it to duplicate each rowthe correct amount of times automatically based on the number in the payment amount cell?

Thanks for your help!

 

[Snakehips]

@Sarah1989 Does something like this help?

MrXL_Aug.xlsm
	A	B	C	D	E
1	Name	Payment			Draw list
2	Player 1	$1.00			Player 1
3	Player 2	$1.00			Player 2
4	Player 3	$3.00			Player 3
5	Player 4	$2.00			Player 3
6	Player 5	$6.00			Player 3
7	Player 6	$1.00			Player 4
8	Player 7	$1.00			Player 4
9	Player 8	$5.00			Player 5
10	Player 9	$6.00			Player 5
11	Player 10	$1.00			Player 5
12	Player 11	$1.00			Player 5
13	Player 12	$1.00			Player 5
14	Player 13	$1.00			Player 5
15	Player 14	$1.00			Player 6
16	Player 15	$2.00			Player 7
17	Player 16	$5.00			Player 8
18					Player 8
19					Player 8
20					Player 8
21					Player 8
22					Player 9
23					Player 9
24					Player 9
25					Player 9
26					Player 9
27					Player 9
28					Player 10
29					Player 11
30					Player 12
31					Player 13
32					Player 14
33					Player 15
34					Player 15
35					Player 16
36					Player 16
37					Player 16
38					Player 16
39					Player 16
40
Sheet2

Cell Formulas
Range	Formula
E2:E1001	E2	=LOOKUP(ROW(A1:A1000),SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$1000)))+1,A$2:A$1000)&""
Dynamic array formulas.

 

[Sarah1989]

I think that could be exactly what I'm looking for, thank you!

 

[Sarah1989]

This formula has been amazing - thank you!

Is there any way to edit it for different monetary values? I've tried tweaking a few things but manage to break the formula every time.

I'm looking to be able to do it where £5 = 1 entry (so £20 would appear 4 times on the pick list) and also where £2 = 1 entry (so £20 would appear 10 times on the pick list)

These would all be on their own spreadsheets for different raffles.

Thanks so much!

 

[Snakehips]

Maybe like below?
Each raffle sheet would be essentially the same but with its own ticket value entered in C2.

Book2
	A	B	C	D	E
1	Name	Payment	Ticket £		Draw list
2	Player 1	$3.00	$3.00		Player 1
3	Player 2	$6.00			Player 2
4	Player 3	$6.00			Player 2
5	Player 4	$9.00			Player 3
6	Player 5	$3.00			Player 3
7	Player 6	$12.00			Player 4
8	Player 7	$6.00			Player 4
9					Player 4
10					Player 5
11					Player 6
12					Player 6
13					Player 6
14					Player 6
15					Player 7
16					Player 7
17
18
Sheet2

Cell Formulas
Range	Formula
E2:E1001	E2	=LOOKUP(ROW(A1:A1000),(SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$100)))/$C$2)+1,A$2:A$100)&""
Dynamic array formulas.

Hope that helps.

 

[Sarah1989]

Thank you so much, that works perfectly! I really appreciate it!