Hi Everyone,

Do you know how to transpose the rows to columns per item? Here's the example

Image A

Image B

Image A is from Worksheet A and Image B is from Worksheet B.

Is there a formula for this?

Thanks.

In Worksheet B, enter A1:B3 manually.

In C1:J1, enter the array formula (confirmed with Ctrl+Shift+Enter)

=TRANSPOSE('Worksheet A'!D2:D9)

In C2, enter the ordinary formula

=INDEX('Worksheet A'!$C$2:$C$17,SUMPRODUCT(('Worksheet A'!$A$2:$A$17=$A2)*('Worksheet A'!$D$2:$D$17=C$1),ROW('Worksheet A'!$A$2:$A$17)-1))

Fill down to C3, then right to column J.