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

[Bo_Ry]

Please try at A53:J57

=INDEX($A$3:$B$47,MOD(COLUMNS(A53:$B53)-1,9)+ROWS(A$53:B53)*9-8,1+(COLUMNS($A53:A53)>1))

[Peter27]

Hi Bo-Ry,

Thank you for your swift reply. I have tried your suggestion, but I can'get it to work yet.
I am sure this is due to me but............

I enclose a small part of the file I am trying to work with.
I tried to work with your solution on page 2.

The original file contains around 2400 rows.

Would you be so kind as to have another look at it,

Thanks for your help

Peter

[JeteMc]

Bo_Ry's formula produced exactly the wished for results in the file attached to post #1.
The file attached to post #3 is quite different and there is no wished for results given so that we might have something to go by when attempting to write formulas/code.

[Peter27]

Sorry for not being clear before.

I have created an example of the situation now and the wished situation in enclosed worksheet.

Hopefully you can help me,

Thanks in advance

[Bo_Ry]

Please try at E2
=INDEX(NOW!$A$2:$I$22,ROWS(A$2:A2)*7-6+MAX(0,COUNTIF($A$1:A$1,"*,*")-1),IF(COLUMNS($A2:A2)>3,IFERROR(1/(1/MOD(COLUMNS($A2:A2),3))+3,9),COLUMNS($A2:A2)))