Formula to show in 4 columns the letters from one column with condition

[Fractalis]

I have a input table like this A1:C21. I'm trying to show (in 4 columns array) the "Letters" that meet the condition
in J2 and K2. In this example I'm getting the letters for which Col_A = 1 and Col_B = "MM".

Below I'm showing the current output using a formula in E2 (borrowed from here), but when I copy across and down, repeats letters
and the letters are shown separated. I'd like to get the letters without separation in 4 columns and needed rows by each case.
Maybe some SPILL function could calculate dinamycally the rows without repetition.

Thanks in advance for any help.

file.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	VALUES	TYPE	LETTERS		CURRENT OUTPUT					VALUE	TYPE
2	1	MM	A		A					1	MM
3	3	MM	B					N
4	1	AS	C				K
5	2	MM	D			H
6	2	AS	E
7	3	AS	F				N
8	3	AS	G			K		S
9	1	MM	H
10	2	AS	I		EXPECTED OUTPUT
11	2	MM	J		A	H	K	N
12	1	MM	K		S
13	1	AS	L
14	3	AS	M
15	1	MM	N
16	3	MM	O
17	1	AS	P
18	2	AS	Q
19	3	AS	R
20	1	MM	S
21	1	AS	T
Sheet1

Cell Formulas
Range	Formula
E2:H8	E2	=UNIQUE(INDEX(IF(($A$2:$A$21=$J$2)*($B$2:$B$21=$K$2),$C$2:$C$21,""),ROWS($A$1:A1)+(COLUMNS($A$1:A1)-1)*4))

 

[Eric W]

Try this in E11:

=IFERROR(INDEX(UNIQUE(FILTER(C2:C21,(A2:A21=J2)*(B2:B21=K2))),SEQUENCE(6,4)),"")

Clear out the existing data first.

 

[Fractalis]

Try this in E11:

=IFERROR(INDEX(UNIQUE(FILTER(C2:C21,(A2:A21=J2)*(B2:B21=K2))),SEQUENCE(6,4)),"")

Clear out the existing data first.

Hi @Eric W I can only laugh that I racked my brain for more than 2 hours on how to do it and it took me longer to write the question than it took you to respond with a solution hahaha . Thanks, thanks, thanks

 

[Cubist]

Another option.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	VALUES	TYPE	LETTERS		CURRENT OUTPUT					VALUE	TYPE
2	1	MM	A							1	MM
3	3	MM	B
4	1	AS	C
5	2	MM	D
6	2	AS	E
7	3	AS	F
8	3	AS	G
9	1	MM	H
10	2	AS	I		EXPECTED OUTPUT
11	2	MM	J		A	H	K	N
12	1	MM	K		S
13	1	AS	L
14	3	AS	M
15	1	MM	N
16	3	MM	O
17	1	AS	P
18	2	AS	Q
19	3	AS	R
20	1	MM	S
21	1	AS	T
Sheet7

Cell Formulas
Range	Formula
I2,I4:I7	I2	=INDEX(IF(($A$2:$A$21=1)*($B$2:$B$21="MM"),$C$2:$C$21,""),ROWS($A$1:E1)+(COLUMNS($A$1:E1)-1)*3)
E11:H12	E11	=WRAPROWS(FILTER(C2:C21,(A2:A21=J2)*(B2:B21=K2)),4,"")
Dynamic array formulas.

 

[Fractalis]

Another option.

Thanks @Cubist for other solution. In my actual data there are several values repeated. How to get unique values in the output with your formula?

 

[Cubist]

You can add UNIQUE().

=WRAPROWS(UNIQUE(FILTER(C2:C21,(A2:A21=J2)*(B2:B21=K2))),4,"")

 

[Fractalis]

You can add UNIQUE().

=WRAPROWS(UNIQUE(FILTER(C2:C21,(A2:A21=J2)*(B2:B21=K2))),4,"")

Thank you, it works! without know too much about this, I changed to yours as the solution due that is shorter.