Scott Panning
New Member
Hi, I am trying to create a spreadsheet where data can be organized based on year or name like it can be on Itunes. In an Itunes library, the rows each correspond with one file. The first column for any row will have the file number, the next will have file name, then the file year, so on and so forth. When any column heading is clicked, it will automatically order all the files based on the data that is in that column, so when the year column heading is clicked, all the files will be organized by year. Click it again, and it will organize them again in the reverse order (1-99, then 99-1). Some columns are organized numerically, others alphabetically. I want to capture this in an excel spreadsheet, where the information in row 45 for example will always be kept together, even when row 45 is moved to row one due to reorganizing. Therefore, what I believe I am asking is: 1. How do I get column headings that will organize data alphabetically or numerically and 2. How do you group data so that all the cells in one row will always be kept together despite reorganization and finally, 3. Is there another application other than excel that I should be using that is designed for this process? Thank you very much, any help is much appreciated.
