Thread: Quite a puzzler - Concatenate for unique entries

Hello,

Presenting below quite a puzzler

I have the following info on 3 columns; i am really curios if i can get the result mentioned below (meaning put the info on column 3 in a single cell where the first two cells have the same info - meaning for the unique two first column which i already have i need to write A,B,C or D,E,F next to them, as in the result)

Is it really possible? Couldn't figure out any solution for this

ARRAY:


Word 1|Opt 1|A
Word 1|Opt 1|B
Word 1|Opt 1|C
Word 2|Opt 2|D
Word 2|Opt 2|E
Word 2|Opt 2|F

Result
Word 1|Opt 1|A, B, C
Word 2|Opt 2|D, E, F