Aligning Data Automatically

Hi there, 

I am trying to align data in a certain way so that I can run formulas through excel. For the work that I am trying to do, there are a lot of individuals with data next to each of their names. I have an example attached for what is given and what my goal is for this project. I understand that I could copy and transpose paste. However, I am working with over 1000 names so this would take way too long