New to this Forum: Help Aligning Data

[mark1niner]

Hi Everyone,

This is my first time posting so I apologize if it is repeated info. I have struggled finding a solution so I come to you.

I have a list of names (around 200), where each name correlates to a number. These numbers differ for each different field, but for the most part, the names stay the same. I can't just sort them by alphabetical order because I need to match them to a designated field. I figured I am not making too much sense so I attached a condensed version of what I have and what I need to get to.

I'm not the best with Excel, but I use it enough to think I am not over looking a simple solution. If I am and someone is easily able to help, I would really appreciate it. Thanks.