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.
Bookmarks