I have a sheet with 2 columns. One is labeled Players the other is labeled points. This has been gathered over several years and as a result, I have the same player name listed multiple times in the player column, but obviously their point total is different each year. What I am wanting to do, is instead of having duplicate names and their scores, I want to keep the sort of players but span the points horizontally across the sheet. so that I can total the players points for some history. I'll list a brief example below of what I current have then what I want so it makes more sense...

abigail87 45
abrnfanatc 561
abrnfanatc 671
abrnfanatc 257
AcctTiger 595
AcctTiger 426
AcctTiger 647
AcctTiger 569
AcctTiger 700
AcctTiger 338
AcctTiger 258
achamb7 254
achamb7 13
adsfr 838
adsfr 566
aed14 315
AG4AU 288
AirForceforAU 73
alabamapaper 120
ALTiger 797
ALTiger 757
ALTiger 569
ALTiger 573


What I want instead is: (when there are duplicate names)

abrnfanatc 561 671 257
AcctTiger 595 426 647 569 700 338 258
etc..

Can I do this using a vlookup or is there something else I need to use for that? I also wouldn't be opposed to having it group by name something like this

abrnfanatc AcctTiger

561 595
674 426
251 etc...