Convert Vertical row data into Horizontal

Hi,

I have a data set from a study with 2023 participants (Sample workbook attached).

There are five recorded variables (C_ID, E_NAME, C_NAME, P_NAME and EVENT_DT). These variables are in the vertical order. I want them Horizontally. I am aware of transpose function but unfortunately that does not work here. I need them in a way that all dates come horizontally and C_ID, E_NAME, C_NAME, P_NAME come once only.

Please the yellow highlighted portion on the right side in the same workbook sheet to get an idea how I want the data. I created by hand to provide the reader with an idea how I want the data. It will be hard to do it for 2023 participants, so please suggest something.

Thanks a lott for the help