Sorting Entire Columns

[jlkirk]

I have approximately 100 columns of data in rows 2-1500. I would like to sort these columns by the name of the column in reow 1. Any help?
Thanks in Advance.

 

[JD_GFI]

Can you provide an example?

 

[jlkirk]

The names Zeke, Samuel, Abraham, Jim, and Mary are in cells A1-E1, respectively. Below their names, beginning in row 2, are each of their weights on various days (1500 days). What I would like to do is "alphabetize" the columns so that the result would be Abraham, Jim, Mary, Samuel and Zeke in columns A1-E1, along with thier respective weights.

 

[JD_GFI]

In Excel 2007 & 2010 you can click on the "Sort" button under the "Data" menu, click the "Options" button and select "Sort Left to Right". This gives you the option to sort by row instead of column.