New FILTER function cannot accept an array in the filter value?

[BrianGGG]

Hi. I have the following reference table:

	A	B
135	Item	Quarter
136	a	2
137	b	3
138	c	3
139	d	1
140	e	4
141	f	1
142	g	4
143	h	2
144	i	3
145	j	1
146	k	1
147	l	1
148	m	3

<tbody>
</tbody>

Summary​

My goal is to "pivot" by the quarter column to create the following output:

	E	F	G	H
136	1	2	3	4
137	d	a	b	e
138	f	h	c	g
139	j		i
140	k		m
141	l

<tbody>
</tbody>

Summary​

Worksheet Formulas Cell Formula E137 =FILTER(t_Items[Item],t_Items[Quarter]=E136) F137 =FILTER(t_Items[Item],t_Items[Quarter]=F136) G137 =FILTER(t_Items[Item],t_Items[Quarter]=G136) H137 =FILTER(t_Items[Item],t_Items[Quarter]=H136) <tbody> </tbody>

<tbody>
</tbody>

As you can see above, the FILTER function works to get the right answer, but I had to copy and paste the filter function across to all four columns.
I was disappointed to see that I got a #VALUE error when I tried to spill a single formula with the following:

=FILTER(t_Items[Item],t_Items[Quarter]=E136:H136)

I can't seem to use an array in the FILTER criteria. Is this the expected behavior and there is no way around this?



thanks
BrianGGG