Lookup multiple values with multiple criteria, fill horizontally same row by header

Hello friends, a long time lurker-first time poster. This place has saved my *** on multiple occasions. Unfortunately, I have now spent days looking for a solution without much luck and felt compelled to ask my first question.

The problem at hand is this. I have a list of employees (by ID) and series of events associated with those employees (going horizontally). Some folks have multiple events taking place during different times (hence the duplicate empl IDs). Below I have highlighted the duplicate rows. Employee ID 701, had a manager change (XFRMng) on 7/20/17 and was promoted (PROM) on 8/17/17. Numbers 47 and 46 that you see in the cells are row counts from the dataset (this is a summary pivot). Soooooooo, how do I update a different sheet (to create an employee "history") by matching the Event categories on top, by capturing multiple dates and then returning them in the same row.

Array.JPG

Here's an image of how it should look

Output.JPG

using the "small" function I managed to identify the row #, but I can't figure out how to specify which column to reference, in order to get the date. Everything that I've read on the subject, only show how to do by using "columns" function but they stop short of showing how to get an exact match.