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...