Transpose similar IDs in single row

Hi guys
In column A there are IDs that are duplicates and need to gather simialr IDs to make each ID in single row then to collect the data related to each ID in adjacent columns
Attachment has a result sheet

Try

Please Login or Register  to view this content.

thanks a million jindon for this fantastic code.
that's exactly what I go after and working like charm