Formula to show values for each element in a summary table

[Fractalis]

Hello to all,

Please your help.

I have items that appear several times in column A and respective values in column B.

I want to show as headers from D1:G1 the values in column A and all the values for each element.

May you help me with a Excel formula to get this goal please.

[TABLE="width: 512"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]BKL[/TD]
[TD]9[/TD]
[TD][/TD]
[TD]BKL[/TD]
[TD]LIN[/TD]
[TD]BJU[/TD]
[TD]TYP[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]LIN[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]9[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]BJU[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]11[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]BJU[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]BKL[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]TYP[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]LIN[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]BKL[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]TYP[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance

 

[azumi]

Put in D2 and copied croos and down until blank results

=IFERROR(INDEX($B$1:$B$9,AGGREGATE(15,6,(ROW($B$1:$B$9)-MIN(ROW($B$1:$B$9))+1)/($A$1:$A$9=D$1),ROW(A1))),"")

 

[Fractalis]

Hello azumi,

Many thanks for your help. It seems to work fine.

Regards