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.

	A	B	C	D	E	F	G
1	BKL	9		BKL	LIN	BJU	TYP
2	LIN	1		9	1	2	8
3	BJU	2		11	5	4	3
4	BJU	4		7
5	BKL	11
6	TYP	8
7	LIN	5
8	BKL	7
9	TYP	3
10

<tbody>
</tbody>

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