Add Blank Cells For People Not On Each Years List So All Names Align

I have 10 columns that are as follows. Name, rank 04, name, rank 05, name, rank 06, name, rank 07, name, rank 08. The longest name and rank list is over 1200 names long. What I need to do is create 1, 3, and 5 year averages based on rank.

My question is, is there a way to sort alphabetically that will automatically align column a,c,e,g,and i alphabetically that will also align each row by name.

example:
name 04 05 06
joe 75 72
paul 82
carl 72 48

Joe isn't present in 05, Paul isn't present in 04 or 06, and Carl isn't present in 06.

Basically I need excel to add blank cells for people not on each years list so all names align.