Excel List of names to raffle

Paste in a list (any amount of columns) making sure that the last column contains the amount of tickets.

Example:
Name
...
Tickets
Name 1
...
5
Name 2
...
2
Name 3
...
6

Paste in Excel data

Winner: