Sort sheet, highlight, undo sort

[js.raju]

Hello, I'm not that good with excel so i'm after abit of help. I've got a document with a list of films as pictured.

1.jpg

What I want to be able to do, is sort it by the "date added" column, highlight a row, and then have it sorted how it was before. I can't sort it by a-z because that messes up the order. So is there a way of doing that?

If not, is it possible to link (in this example) row 19, 20, 21 to row 18. But have them separate so I can sort it by year and have them all show individually but then when sorted by a-z, they show up how it is pictured.

Please ask any questions as I know it sounds abit confusing. Thank you for any help

[shg]

Put the collection name in the first column, repeated as necessary, then remove it from the title column. Then you can sort however you like.