combine data from multiple rows into a single row

Test_Data.xlsx

Hi, I want to acheive this functionality how can i do it.

I tried group by and use list and then split column collection.

The challenge i am facing when did that was when split, it loses the column names and also in cases where a UDSEQN is missing, then when split, I am not able to map them correctly