sorting data in 1 column to rows

[Peter27]

I have a file where in column A I have an item number.
In column B I have components that are part of this item number.
In colum A the item nuber is repeated 7 or 8 times, each time with a different component.

I would like to re-arrage the file to have the item number in column A en the components in colums B......I

Please see enclosed file

Thanks for your help