Transpose issue

Hi

As my username may suggest I am pretty new to both Excel and this forum , this is my first post in fact. I have attached the file containing parts of my data ( it apparently exceeded maximum file size) as it may make it easier to understand what im trying to do.

I am trying to transpose the data in the "Length" column so it ends up paired with correct ID in rows as can be seen on the right hand side. I have not been able to find any other way of doing this except manually selecting the "Length" data belonging to one ID and then copy - transpose. Surely I am overlooking some less time consuming way of transposing than to manually copy paste thousands of times?

I would be extremely grateful for any suggestions of less time consuming ways to transpose the data.

Alright , thank you for trying tho. Any suggestion on how I could group ID's together in a smart way?

Im not sure what im doing wrong but i keep getting error messages when trying to apply the formula after sorting as suggested , it would help me greatly if someone could exactly what goes where in the row and column brackets in the formula since i suspect it may be my inexperience causing problem. Also thank you both for the quick replies and suggestions =)

I offer this option.

That does indeed seem to be a neat solution to my problem , I will try to apply it to my larger dataset and see if it works there as well. Thank you =)

Hi
Try these formula and copy right and down
=IF(AND(OFFSET($A2,COLUMN(A$1)-1,0)=COLUMN()-10,I2<>""),IF($A2=0,OFFSET($B2,COLUMN(A$1)-1,0),""),"")

Formula:

=IF(AND(OFFSET($A2,COLUMN(A$1)-1,0)=COLUMN()-10,I2<>""),IF($A2=0,OFFSET($B2,COLUMN(A$1)-1,0),""),"")

Alright I tried Czeslaws suggestion and while it does seem to work for the first 10-15 rows it then displays the rest as blank ( the code is present though) and it seems to calculate without progressing. Any ideas as to why this is happening?

José im not quite sure how to use the formula you provided , what do i put in the empty column bracket ?

Hi
My formula is to be used in J2 and transpose the values in column B till the age is equal to 0.
See the file Data(2).xlsx
Regards

I think i may have solved the problem i had with Czeslaw's suggestion on my end , il mark this post as solved. A BIG thank you to all of you, you have all helped me a lot =)