SOLVED

Can array results be return in rows

New Contributor

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

CDEFG
1Item Id

Category

 Item IdCategories  
21Red 1RedBlueGreen
31Blue 2Red  
41Green 3Green  
52Red     
63Green     
        
3 Replies
best response confirmed by I_dont_want_mentions (New Contributor)
Solution

@I_dont_want_mentions 

You may use

=TRANSPOSE(FILTER(B:B,A:A=A2))
That's it! Thanks!
Ethan