Can array results be return in rows

[I_dont_want_mentions]

I would like to be able to get Array Results return in rows rather than in columns. Is that possible?

Very simple example:

I would like to be able to get output on the right. When I use the filter function in cell E2 like

=Filter(B:B,A:A=A2)  it fills down column E rather than across row 1

Hello world

	A	B	C	D	E	F	G
1	Item Id	Category		Item Id	Categories
2	1	Red		1	Red	Blue	Green
3	1	Blue		2	Red
4	1	Green		3	Green
5	2	Red
6	3	Green

[#2 · Accepted solution]

@I_dont_want_mentions 

You may use

=TRANSPOSE(FILTER(B:B,A:A=A2))

[#3]

That's it! Thanks!
Ethan

[#4]

@I_dont_want_mentions , glad to help