easy way to get unique rows

Follow

Saurabh Agashe

• April 16, 2015 19:14

Hi,

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.

Thanks!

0

• Official comment

  

  Saurabh Agashe

  • April 16, 2015 19:15

  You can easily accomplish this by using a GROUPBY on the name, then use another GROUPBY on the age. This will create a subgrouping based on the name. Please see my screen shots below for visual reference.

  

  

  Comment actions Permalink

Please sign in to leave a comment.