Please see the attached example in excel format for clarification. Note the explanatory comments
In column A is a list of documents by Document ID. In a separate table each Document ID is repeated in a row every time that an event is logged for that document (Events are identified by Event ID numbers 1-6). For each event that occurs at a given document the 'Event Date' is logged in another column.
I want all of the Event IDs for a given Document ID to be displayed in one row by the date that they occurred, as pictured in the attached example.
Any assistance would be greatly appreciated as this is far beyond me level of excel expertise.
Bookmarks