sorting issues

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.

Hi,

VLOOKUP will be a good solution to this, kindly post a sample of your work sheet.

Blalock, Hank 252 Blalock, Hank 183 Blalock, Hank 184 Blalock, Hank 81 Blalock, Hank 87
Blanco, Andres 17 Blanco, Andres 9 Blanco, Andres 16 Blanco, Henry 3 Blanco, Gregor 129
Blanco, Henry 76 Blanco, Henry 46 Blanco, Henry 61 Bloomquist, Willie 43 Blanco, Henry 25
Blanco, Tony 0 Blanco, Tony 9 Bloomquist, Willie 72 Blum, Geoff 79 Bloomquist, Willie 66
Bloomquist, Willie 46 Bloomquist, Willie 55 Blum, Geoff 57 Bocachica, Hiram 19 Blum, Geoff 98
Blum, Geoff 78 Blum, Geoff 73 Bocachica, Hiram 5 Bonds, Barry 279 Bocock, Brian 8
Bocachica, Hiram 22 Bocachica, Hiram -1 Bohn, T.J. 3 Bonifacio, Emilio 7 Boggs, Brandon 80
Bonds, Barry 493 Bonds, Barry 29 Bonds, Barry 270 Boone, Aaron 63 Bohn, T.J. 4
Boone, Aaron 0 Boone, Aaron 135 Boone, Aaron 104 Borchard, Joe 38 Bonifacio, Emilio 41

as you can see the names don't line up by row, and that is my goal. Any help would be much appreciated. I have spent several hours doing it manually, but could take several days to complete.

Thanks,
Tim

why not excel worksheet instead of the text, so i can fix in some worksheet function(formula)

new at asking for help online. Big file. Last tab named TLR averages.

I have inserted a new sheet 1 for the solution.

Check if it is okay.

That is what I want it to look like, but it hasn't kept the value that corresponds to each persons rating for each year. If you look at the first 20 or so people on the list you will see that some people have blank cells since they have no data for that year. What I am trying to do is have excel automatically put those blank cells in so that the names line up across the worksheet. Any more help would be appriciated, and I thank you for your help.

Would someone mind taking a look at this. I have been messing with the worksheet for days, and can't find any way to do this other than manual. I would really appreciate it.

Thanks,
Tim

Bump. Move to top.

Herbs7 thank you so much that is exactly what i was looking for. I will play around with pivot tables since it appears that is how you did it.

SHG thanks for the help as well, but Herbs7 beat you to the punch.

Thanks to everyone else that helped along the way.