Combining rows if 2 values are met

Originally Posted by losc

Thank you this seems to be working perfectly! In my actual database I use columns A-AB. After expanding from CelD onwards instead of using CelY for year and CelT for the text and CelS can I just use AC, AD, AE?

Sorry - I'm not picturing this .. it's fairly easy to expand and if you've managed to get it sorted then great; if not, attach the real file and I'll adjust it for you.