I have rows like:
Tom, 16 Alice, 19 Tom, 16 Tom, 17
In my Workbook, is there any easy way to get (unique rows only) : Tom, 16 Alice, 19 Tom, 17
Right now, I'm concatenating the 2 columns, doing a GROUPBY and finally splitting into 2 columns again.
Please sign in to leave a comment.