Forum Discussion
Solved
Can array results be return in rows
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 | |||||
3 Replies
- That's it! Thanks!
EthanI_dont_want_mentions , glad to help
