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
Bookmarks