How do i align multiple columns in excel by name and sales?

One possible solution may be to insert enough columns after 'C' to allow for the number of quarters being reported. Then, in each column from 'D' to 'col n', use a vlookup of the name from 'B' to find that name's corresponding value from 'D' and 'E' (which will be different columns than shown as you have inserted more columns. Then, each name in 'B' will show their relative sales by quarter.

I see that you have the same agents in all months. Here's a technique:

1. Move Columns D and E to a new sheet (Sheet2) and F and G to another (Sheet3).
2. Arrange all three sheets alphabetically. Here's how:
   • Select the names column on each Sheet1.
   • Go to Data tab.
   • In the Sort & Filter group, click the Sort A to Z button. Both the Agent name and sales columns will be sorted according to the alphabetical order of names.
   • Repeat procedure with Sheet2 and Sheet3 so all sheets are sorted by alphabetical order of names.
3. Move the data of Sheet2 and Sheet3 back into Sheet1.