Transpose with repeat

Hi,

I have the data in the excel in the form mentioned below.
P212J762 ANR-HEADER
P212J762 ANR-DATA
P212J762 ANR-TRAILER
P212J329 ANR-HEADER
P212J329 ANR-DATA
P212J329 ANR-TRAILER
P212J329 KONTO4

I want it in the format mentioned below,
P212J762 ANR-HEADER ANR-DATA ANR-TRAILER
P212J329 ANR-HEADER ANR-DATA ANR-TRAILER KONTO4

Please let me know if it is possible using Pivot table.