Brunssl2, it sounds as though you want a macro to do the following:

1) Create a new target worksheet.
2) Sort the source worksheet by column 18, if it isn't already. (Col Q, I take it?)
3) Go through the source worksheet row by row, collecting the dates for a single event code. When you come to the end of an event code, write out the combined row in the target worksheet and continue.

You're on the right track; this is a perfect use for a VBA program. But what part of the above do you need help with? Have you ever written in VBA before? Where are you starting?