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

With the addition of a "key" column to create an easily indexable column, you can accomplish this without array formulas, too. Here's my take.

In this version, the column H values work themselves out, too.

It makes me think you didn't look at the sample I uploaded at all. Here's the exact same sheet again but with the new data from your post above pasted into columns A:E.

The key column I added to column F and all the formulas in H:T are unchanged.

Go team!

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.