Transfer vertical data into horizontal data

Hello,

I need to transfer data (part numbers) that belong each to one article number, from a vertical table format into a horizontal format.
Example: see attachment.

I tried to insert two columns to sort the data and add numbers but somehow it didn't work.
Does somebody have an idea what formula to use in this case?

Thanks a lot!