I have a database with information organized as such:

- For each event, there may be anywhere from 1-6 rows, each detailing a certain aspect of the event.

- There are around 30 columns.

- For each event, there is data that could be the same for each event (so, each cell would be the same in the column for each of its 1-6 rows) and some that are different.

- For example, if the database is detailing attendees to company events, the event name would be "Mid Summer BBQ" (cells A13-A15 would all be 'Mid Summer BBQ'), the month would be July for B13-B15, the location would be 'Park' for C13-C15. But, I may have a column for 'Department' and 'Attendees', in which case D13-D15 and E13-E15 would all be different.

- Each event is separated by a single empty row.

I'd like to have an automated process where I can select a certain aspect of the event that would be unique (Location or Month in above example) and have it spit back only those events in a separate sheet, with the same format (same number of rows, with a single blank row separating them).

I hope I've explained it well, please let me know if any clarification is needed.