Group row in columns

Hello, I have an excel table like:

name1 A
name2 B
name3 C
name2 C
name3 A
name4 A
name1 B
name1 C

and I need to group them like:

name1 A B C
name2 B C
name3 C A
name4 A