Arranging data in a column of a particluar account in to adjecent cells to get in a row

[harykrish]

Hello Every one,

Kindly try to help me on the below. I have data like as in teh attached spread sheet.
I want teh data as mentioned belwo....
1.The trade seq has been repeted for many times.
2. The data like Bene act , Depo id , safe acct, Narative line1/2/3/4 are repeating for few trade seq numbers.
3. I want to get the data relating to an acct should be populated ina sigle row under their respective column heads.
4. I have updated manually for better understanding.
5. PLease advice me how to do the same in automated way.
6. PLease use the updated attachment from teh above attached( With Red and Yellow Colors).

Regards
Harikrishna
+918886215554