merge equal cells in one cell

[aXpress]

Hi!
I there anyway to marge equel cells?
For example:
I have table:
A B
1 red
1 yelow
1 green
2 blue
2 black
3 brown

I whant to get table
A B
1 red yelow green
2 blue black
3 brown

Thanks.

[BlastRanger]

Hi there you can use Index and Small combined with Array Formula.

See my attachment for the example