I want to know if there is a formula I can use that would match up the
same names from the 2 columns and put it in the same row with their
results (i don't know if i'm explaining this correctly), instead of
doing it manually. See below:
Thanks!

A B C D
Charles 1 Peter 4
Peter 2 Xavier 3
Allison 3 Kim 7
Xavier 5 Nancy 6
Nancy 6 Edward 8
Edward 7 Pedro 9
Susan 8 Carlos 9
Kim 9


This is what I want it to look like:

A B C D
Charles 1
Peter 2 Peter 4
Allison 3
Xavier 5 Xavier 3
Nancy 6 Nancy 6
Edward 7 Edward 8
Susan 8
Kim 9 Kim 7
Carlos 9
Pedro 9