Sorting one record multiple times
I have an Excel spreadsheet that lists multiple dates for one record. The information in the spreadsheet is Movie Title, Country and Date. There are multiple Countries for each Movie Title and vice versa. I need to be able to sort all of the Dates chronologically for each Movie Title (listing the Countries and their Dates) and then by Country (listing the Move Titles and their Dates), but this would require that the one record be duplicated multiple times for each of those sorts.
I have managed to import the sheet by Movie Title, and then transpose the data and import the sheet by Country.
Any ideas on what can be done short of creating a duplicate script to make each Movie Title, Counrty and Date it's own record?