I am trying to create a list that is similar to how iTunes organizes its music.

I'm trying to create three columns (Year, Film, Director) in excel. That part is easy.

But i want to be able to organize/sort the columns easily.



For instance if I want to view all the rows by year, i would be able to do either ascending or decending. If i want to view all the rows by the the film, i want to view it alphabetically and in reverse. If i want to view the rows by director, i want to view it alphabetically and in reverse.

How do I achieve this with keeping the rows (Year, Film, Director) in tact whenever I switch the ascending/descending ordering of something?

Basically, I want to do an itunes version of a list of movies that can be sorted out easily.

Thank you