Convert Vertical row data into Horizontal

If the C_IDs can simply be 1,2,3,4... down one column, then VLOOKUP can return the E_NAME, C_NAME and P_NAME, while an array formula filled down rows and across columns can return the dates.
See Sheet 2 of attached doc.