Seperate Data by trade ID and Date

[malleshg24]

Hi Team,


Columns A Contains Trade ID and Columns E Contains Date,


My Task is to take only Unique Trade ID. and update its file name in date wise columns.
if repetation of trade ID in any Date, dont add extra row in output,


Attached is input File, Column A to E is my Data, and Expected output is in Column I to P.




Thanks in advance for your help!






Regards,
mg